Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Excel Online Structured Activity: Descriptive Statistics and Finding Common Measures of Location Sample data typical of the cost of tax-return preparation by services such

 

Excel Online Structured Activity: Descriptive Statistics and Finding Common Measures of Location Sample data typical of the cost of tax-return preparation by services such as H&R Block are located in the Microsoft Excel Online file below. Use the spreadsheet to answer the following questions. ***** Open spreadsheet a. Compute the mean, median, and mode. Round your answers to one decimal place, if necessary. Mean Median Mode b. Compute the first and third quartiles using Excel's QUARTILE.EXC function. Round your answers to one decimal place, if necessary. 112.5 252 149.7 125 125 Qi Q c. Compute the 90th percentile using Excel's PERCENTILE.EXC function. Round your answers to one decimal place, if necessary. 100 Cost 120 215 110 115 160 130 150 105 200 155 105 350 120 120 145 100 115 185 235 255 Mean Median Mode + Q1 Q3 90th Percentile Formulas Used #N/A #N/A #N/A #N/A #N/A #N/A

Step by Step Solution

3.47 Rating (144 Votes )

There are 3 Steps involved in it

Step: 1

A 1 Cost 2 N 3 st 4 5 6 7 8 00 9 10 11 12 13 14 15 16 25 17 18 19 ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Statistics For Business And Economics

Authors: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams

11th Edition

978-0324783254, 324783256, 978-0324783247, 324783248, 978-0538481649

More Books

Students also viewed these Accounting questions