Module 2 Excel Set 1

20 points total
Help for using Excel is at the end of each chapter reading. Use this file to insert your results and
answer the following questions.
A reminder that each student in this course is expected to abide by the Utah State University
Code of Academic Integrity. Any work submitted by a student in this course for academic credit
will be the student's own work. You are encouraged to study together and to discuss
information and concepts covered in lecture and the sections with other students. You can give
"consulting" help to or receive "consulting" help from such students. However, this permissible
cooperation should never involve one student having possession of a copy of all or part of work
done by someone else, in the form of an email, an email attachment file, a diskette, or a hard
copy. Should copying occur, both the student who copied work from another student and the
student who gave material to be copied will both automatically receive a zero for the
assignment.

Question 1 1 pts
2.8 (a) Construct a Pareto diagram. Create the diagram in Sheet1 of your Excel workbook and
copy your results below.

Question 2 1 pts
2.8 (a) Interpret the results of the Pareto diagram you created for the previous question in the
box below.

Question 3 1 pts
2.8 (b) Construct a pie chart for network type only. Create the diagram in Sheet1 of your Excel
workbook and copy your results below.

Question 4 1 pts
2.8 (b) Interpret the results of the pie chart you created for the previous question in the box
below.
The next 4 questions are based on Exercise 2.13 (page 50) from the textbook. After reading
Exercise 2.13, you will need to copy the table shown in the textbook into Excel in the second
worksheet (Sheet2) to answer the following questions.

Question 5 1 pts
2.13 (a) Create the pie chart described in 2.13 (a) in Sheet2 of your Excel workbook.
Question 61 pts
2.13 (b) Create the pie chart described in 2.13 (b) in Sheet2 of your Excel workbook.
Question 7 1 pts
2.13 (c)
Create the side-by-side bar charts described in 2.13 (c) in Sheet2 of your Excel workbook and
cut and paste below.

Question 8 1 pts
2.13 (d) Answer question 2.13 (d) below.

The next 2 questions are based on Exercise 2.14 (page 50) from the textbook. After reading
Exercise 2.14, you will need to copy the table shown in the textbook into Excel in
the third worksheet (Sheet3) to answer the following questions.

Question 9 1 pts
2.14 Create a graph to answer Exercise 2.14 in Sheet3 of your Excel workbook and cut and
paste below.

Question 10 1 pts
2.14 Do you agree with the statement made in 2.14 based on the graph you created in the
previous question?

Yes
No

The next 2 questions are based on Exercise 2.24 (page 59) from the textbook. After reading
Exercise 2.24, you will need to copy the data into Excel in the fourth worksheet (Sheet4) to
answer the following questions. (Note: the dataset is located under Files --> HOMEWORK
DATASETS --> SANIT.xlsx)

Question 11 1 pts
2.24 (a) For this question, only create a histogram of the data, and put it in Sheet4 of your Excel
workbook.
Question 12 1 pts
2.24 (b) Use the histogram created in the previous question to answer 2.24 (b). The question
asks for a proportion, so your answer should be between 0 and 1 (not a percentage). Enter your
answer in the box below.
The next 6 questions are based on Exercise 2.26 (page 60) from the textbook. After reading
Exercise 2.26, you will need to copy the data into Excel in the fifth worksheet (Sheet5) to
answer the following questions. (Note: the dataset is located under Files --> HOMEWORK
DATASETS --> NFL.xlsx)

Question 13 1 pts
2.26 (a) Create a histogram for part (a) in Sheet5 of your Excel workbook and cut and paste
below

Question 14 1 pts
2.26 (a) Briefly describe the distribution you created in the previous question below.

Question 15 1 pts
2.26 (b) Create a histogram for part (b) in Sheet5 of your Excel workbook and copy below.

Question 16 1 pts
2.26 (b)
Briefly describe the distribution you created in the previous question below.

Question 17 1 pts
2.26 (c)
Create a histogram for part (c) in Sheet5 of your Excel workbook and copy below

Question 18 1 pts
2.26 (c) Briefly describe the distribution you created in the previous question in the box below.

Question 19 2 pts
Email both the word file and the Excel workbook you used for this assignment.