Excel Online Structured Activity: Descriptive Statistics and Finding Common Measures of Location Sample data typical of...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 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
Expert Answer:
Answer rating: 100% (QA)
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 ... View the full answer
Related Book For
Statistics For Business And Economics
ISBN: 9780538481649
11th Edition
Authors: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams
Posted Date:
Students also viewed these accounting questions
-
Use Spreadsheet 18.1 to answer the following questions about Executive Fruit. a. What would be the required external financing if the growth rate is 15% and the dividend payout ratio is 60%? b. Given...
-
Use the diagram to answer the following questions (ad). a. At the equilibrium price before the tax is imposed, what area represents consumer surplus? What area represents producer surplus? b. Say...
-
Use the following graph to answer the following questions about Jill Johnson's isoquant curve. a. Which combination of inputs yields more output: combination A (3 ovens and 2 workers) or combination...
-
The P04_18.xlsx file contains a single-table Data Model on a companys sales and a single blank worksheet. The goal is to create a pivot table that shows the ratio of average revenue per transaction...
-
Explain how a Gantt chart differs from a CPM/PERT network, and indicate the advantage of the latter.
-
Adam has filed as head of household. She divorced and received $4000 /year in alimony. Adam claims the children as her dependents, but the expenses are divided 50/50 with her ex-husband. Adam's...
-
List and distinguish the three views of structural modeling in the context of an example.
-
Georgia Orchards produced a good crop of peaches this year. After preparing the following income statement, the company is concerned about the net loss on its No. 3 peaches. In preparing this...
-
You create a new project roadmap that is visually appealing and contains all the information for the stakeholders to reference. However, this document took a lot of time to create and has caused some...
-
Kicking It Corp. is planning to open a football camp in Arizona, which will require a land purchase and facilities development that includes fields, sleeping and dining facilities, maintenance...
-
The following transactions occurred during June for Campus Cycle Shop. Record the transactions below in the T accounts. Place the letter of the transaction next to the entry. Foot and calculate the...
-
Hw to chose which use cases are going to be analyzed first?
-
What is an Enumeration and how to use it in conceptual modeling?
-
How to find associations in the text of a use case?
-
Why IFML notation needs dataflows that are not navigable?
-
Can a simple system event send data to both a query and a command? Give an example.
-
RK is just born. It is expected that RK will start college at the age of 16 and will finish her undergraduate studies after 3 years. Currently, college costs are $28,000 per year and are expected to...
-
Charles owns an office building and land that are used in his trade or business. The office building and land were acquired in 1978 for $800,000 and $100,000, respectively. During the current year,...
-
A factorial experiment involving two levels of factor A and three levels of factor B resulted in the following data. Test for any significant main effects and any interaction. Use .05. Factor B...
-
Use the price data in exercise 18 to compute a Paasche index for the shipping cost if 2009 quantities are 4000, 3000, 7500, and 3000 for each of the four products. In exercise 18 Mean Shipping Cost...
-
With double-digit annual percentage increases in the cost of health insurance, more and more workers are likely to lack health insurance coverage (USA Today, January 23, 2004). The following sample...
-
Consider the multiple linear regression model fit to the baseball data in Problem 3.41. Problem 3.41 Consider the 2016 major league baseball data in Table B.22. While team ERA was useful in...
-
Consider the simple linear regression model fit to the rental price data from Problem 2.36. Data From Problem 2.36 Table B.24 contains data on median family home rental price and other data for 51 US...
-
Consider the multiple linear regression model fit to the rental price data in Problem 3.42. Problem 3.42 Table B.24 contains data on median family home rental price and other data for 51 US cities....
Study smarter with the SolutionInn App