Please answer 1-8The caution reads: Where it is appropriate, your answer cell in the spreadsheet must either contain an excel function or formula or it must reference a cell that contains a function or formula. An answer cell with only a number in it will receive no credit.
SCENARIO: A car manufacturer wants to estimate the city miles per gallon (MPG) for a new model, so the company takes a random sample of 45 cars and tracks the city MPG for a specified number of miles. The data are CAUTION: Where it is appropriate, your answer cell given below. Use the data to answer the questions that follow. Show any preliminary Excel work on this worksheet the spreadsheet must either contain an Excel function to the right of the problem information. Each answer is worth one point. You must use Excel functions and/or formula or it must reference a cell that contains a formulas (for example, for the average, etc.) and Excel graphs to obtain credit for your answers. I will check the function or formula. An answer cell with only a numb appropriate cells to be sure you have used Excel functions/formulas. Show your numerical answers to three it will receive no credit. decimal places. Sample of 45 Mileages 30.8 30.9 32.0 32.3 32.6 31.7 30.4 31.4 32.7 31.4 30.1 32.5 30.8 31.2 31.8 31.6 30.3 32.8 30.6 31.9 $2.1 31.3 32.0 31.7 32.8 33.3 32.1 31.5 31.4 31.5 31.3 32.5 32.4 32.2 31.6 $1.0 31.8 31.0 31.5 30.6 32.0 30.4 29.8 31.7 32.2 Answers Question I What is the sample average of the 45 mileages? Question 2 What is the sample standard deviation of the 45 mileages? Question 3 What is the median of the 45 mileages? Question 4 What is the range of the 45 mileages? Question 5 What is the value for the 40th percentile of the 45 mileages? Using the class intervals shown below, create a relative freqency table for this data. Class Frequency Relative Freq. x 33 Answers Question 6 What proportion of the 45 cars achieved an MPG of 31.0 or less? You may show your answers as a decimal Question 7 What proportion of the 45 cars achieved an MPG of 32.0 or more? or percentage. Question & Generate a relative frequency histogram and move it into the yellow area below.Using the class intervals shown below, create a relative freqency table for this data. Class Frequency Relative Freq. x 33 Answers Question 6 What proportion of the 45 cars achieved an MPG of 31.0 or less? You may show your answers as a decimal or percentage. Question 7 What proportion of the 45 cars achieved an MPG of 32.0 or more? Question & Generate a relative frequency histogram and move it into the yellow area below. Questions 9/10 Assuming the mileages are mound-shaped, the Empirical Rule states Lower limit that 95% of the mileages will be between and Upper limit
