02 Feb 1. Develop a graph or table

Complete the problems below from the textbook. You will need to use the “Buena School District Bus Data” and the “Century National Bank Data” files for this assignment.

Chapter 3 – Problem 88

Chapter 4 – Problem 25

Chapter 4 – Problem 46

Chapter 5 – Problem 94

Chapter 4 Case A – Century National Bank

For problems requiring computations, please ensure that your Excel file includes the associated cell computations and/or statistics output. This information is needed in order to receive full credit on these problems.

Submit output in one Excel file.

You are not required to submit this assignment

88. Refer to the Buena School District bus data. Prepare a report on the maintenance cost for last month. Be sure to answer the following questions in your report.

a. Around what values do the data tend to cluster? Specifically what was the mean maintenance

cost last month? What is the median cost? Is one measure more representative

of the typical cost than the others?

b. What is the range of maintenance costs? What is the standard deviation? About 95% of

the maintenance costs are between what two values?

Chapter 4

25. The Director of Planning for Devine Dining Inc. wishes to study the relationship between the gender of a guest and whether the guest orders dessert. To investigate the relationship, the manager collected the following information on 200 recent customers.

a. What is the level of measurement of the two variables?

b. What is the above table called?

c. Does the evidence in the table suggest men are more likely to order dessert than

women? Explain why.

46. Refer to the Buena School District bus data.

a. Refer to the maintenance cost variable. Develop a box plot. What are the first and thirdquartiles? Are there any outliers?

Chapter 5

94. Refer to the data on the school buses in the Buena School District. Set up a variable that

divides the age of the buses into three groups: new (less than 5 years old), medium (5 but less than 10 years), and old (10 or more years). The median maintenance cost is $456.

Based on this value, create a variable for those less than or equal to the median (low maintenance)

and those more than the median (high maintenance). Finally, develop a table to

show the relationship between maintenance cost and age of the bus.

a. What percentage of the buses are new?

b. What percentage of the new buses have low maintenance?

c. What percentage of the old buses have high maintenance?

d. Does maintenance cost seem to be related to the age of the bus? Hint: Compare the

maintenance cost of the old buses with the cost of the new buses? Would you conclude

maintenance cost is independent of the age?

Chapter 4 Case A – Century National Bank

1. Develop a graph or table that portrays the checking balances. What is the balance of a typical customer?

Do many customers have more than $2,000 in their accounts? Does it appear that there is a difference in the

distribution of the accounts among the four branches? Around what value do the account balances tend to cluster?

2. Determine the mean and median of the checking account balances. Compare the mean and the median

balances for the four branches. Is there a difference among the branches? Be sure to explain the difference

between the mean and the median in your report.