Question: Please answer this with excel and attach the excel document Parttofl: Use the data set linked below containing repair costs at a local auto shop

Please answer this with excel and attach the excel document

Please answer this with excel and attach the excel document Parttofl: Usethe data set linked below containing repair costs at a local auto

Parttofl: Use the data set linked below containing repair costs at a local auto shop to create a frequency table or pivot table (3 pts.) and histogram (3 pts.) with 6 bins in Excel. The rst bin should encompass 51- 125, so your bin width is 75. Be sure that your histogram has an appropriate title and labels. Then use excel to compute the summary statistics. Highlight mean, standard deviation. median and rarge [2 pts total). Submit your excel spreadsheet containing the histogram and summary statistic, then use your results to answer the other part of this question. Make sure your le submission is in excel format (ending in .xlsx u' .sls]. MM Mh F'le Bmwse My Computer | i Browaeconherrtmtacon QUESTION 4 ' 5poln1l in Part 1 of 2: Is it appropriate to use the mean and standard deviation to summarize these data? Why or why not? If the normal model is appropriate, give the normal model, NUJ, (I) with each value rounded to the nearest cent. It the normal model is not appropriate, give the median and range of the data with each value rounded to the nearest oenL 'rrIelvar-umlArI-I Elna xnnqnng 0f: ommupsvll\".f, Ettmu nmcss \f

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!