Answered step by step
Verified Expert Solution
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 ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started