Reference no: EM132434507
Complete the problems below.
You will need to use the "Lincolnville School District Bus Data" and the "Century National Bank Data" files for this assignment.
Question 1. Refer to the Lincoinville 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?
Question 2. Refer to the Lincoinville school bus data. 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 $4,179. 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 cost). Finally, develop a table to show the relationship between maintenance cost and age of the bus.
|
Dessert Ordered
|
Male
|
Female
|
Total
|
|
Yes
|
32
|
15
|
47
|
|
No
|
68
|
85
|
153
|
|
Total
|
100
|
100
|
200
|
a. What percentage of the buses are less than five years old?
b. What percentage of the buses less than five years old have low maintenance costs?
Question 3. 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.
Question 4. Refer to the Uncolnville School District bus data.
a. Referring to the maintenance cost variable, develop a box plot. What are the minimum, first quartile, median, third quartile, and maximum values? Are there any outliers?
b. Using the median maintenance cost, develop a contingency table with bus manufacturer as one variable and whether the maintenance cost was above or below the median as the other variable. What are your conclusions?
Attachment:- lincolnville school district bus data.rar