The following data gives the distances that a sample of Johannesburg car owners drive during one...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The following data gives the distances that a sample of Johannesburg car owners drive during one week. Distance driven (km) 114 69 91 24 61 107 110 120 42 146 255 95 143 110 77 281 146 266 120 85 144 106 149 373 150 95 66 130 125 103 87 (a) Compute the mean, mode, median, range, standard deviation, variance, coefficient of varia- tion, lower quartile, and upper quartile of the data using the formula bar and attach a screen- shot of the spreadsheet with the data as well as the values calculated. [Use the formulas, not the Excel analysis toolpak] (20) (b) Use the Excel analysis toolpak to obtain the same descriptive statistics of the data and attach the screenshot of the spreadsheet including the output. (15) (c) Calculate the 90th and 10th percentiles of the data set. (5) The following data gives the distances that a sample of Johannesburg car owners drive during one week. Distance driven (km) 114 69 91 24 61 107 110 120 42 146 255 95 143 110 77 281 146 266 120 85 144 106 149 373 150 95 66 130 125 103 87 (a) Compute the mean, mode, median, range, standard deviation, variance, coefficient of varia- tion, lower quartile, and upper quartile of the data using the formula bar and attach a screen- shot of the spreadsheet with the data as well as the values calculated. [Use the formulas, not the Excel analysis toolpak] (20) (b) Use the Excel analysis toolpak to obtain the same descriptive statistics of the data and attach the screenshot of the spreadsheet including the output. (15) (c) Calculate the 90th and 10th percentiles of the data set. (5)
Expert Answer:
Answer rating: 100% (QA)
Question COMPUTING ALL THE VALUES USING FORMULA BAR MEAN AVERAGEA2A33 MEDIAN ... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
A grocery store owner has found that a sample of customers purchased an average of 3.0 pounds of luncheon meats in the past week, with a sample standard deviation of 0.5 lb. a. If the stores meat...
-
The file FastFood contains the amount that a sample of nine customers spent for lunch ($) at a fast-food restaurant: a. Compute the mean and median. b. Compute the variance, standard deviation,...
-
The file contains the amount that a sample of nine customers spent for lunch ($) at a fast-food restaurant 4.20 5.03 5.86 6.45 7.38 7.54 8.46 8.47 9.87 a. Construct a 95% confidence interval estimate...
-
Determine the void ratio of a soil if its bulk density is 2.06 g/cc and it has a moisture content of 24 percent. The specific gravity of the soil particles is 2.75. Also, determine its dry density...
-
Big Burgers is in the fast-food restaurant business. One component of its marketing strategy is to increase sales by expanding in foreign markets. It uses both financial and nonfinancial quantitative...
-
How are continuous fibers typically oriented in fibrous composites? (A) Aligned (B) Partially oriented (C) Randomly oriented (D) All of the above
-
On a low-friction track, a \(0.66-\mathrm{kg}\) cart initially going at \(1.85 \mathrm{~m} / \mathrm{s}\) to the right collides with a cart of unknown inertia initially going at \(2.17 \mathrm{~m} /...
-
Dougs Diner is planning to expand operations and is concerned that its reporting system might need improvement. The master budget income statement for the Downtown Dougs, which contains a...
-
Consider the topology. 1. Replicate the topology in Packet Tracer. 2. Configure the IP settings and static routes using next hop addresses (optional: you may use loopback interfaces on the routers if...
-
You believe that the Malaysian stock market is expected to underperform the Hong Kong stock market. You would like to use FBMKLCI futures and Hang Seng Index Futures to make profit. What is the best...
-
There are three errors on the below trust account bank statement. Identify and label these: Click the 'Add a Label' Button or click anywhere on the image to add a Label Add a Label 3/3 Labels...
-
ANALYTICS (5%) For each platform, outline how you will measure analytics and include which metrics you will be measuring to track success? Set benchmarks for each platform's metrics.
-
In Lehr v. Robertson, the United States Supreme Court suggested for the first time that the United States Constitution imposes limits on the power of the states to terminate the parental rights of...
-
The intention of this assignment is to give you exposure to a professional in a career of your interest. My hope is that you can learn 'the day in the life' of a person in this career path and...
-
Draw a chromosome map of these two genes in the F1 plants (if needed indicate distance). Indicate which alleles are on each of the chromosomes together. Why does this matter? What are the gametes...
-
This exercise uses the normal probability density function and requires the use of either technology or a table of values of the standard normal distribution. The cash operating expenses of the...
-
What is the role of business risk analysis in the audit planning process?
-
Suppose that there are 6 deaths due to bladder cancer among workers in a tire plant from 1/1/64 to 12/31/83, while 1.8 are expected based on U.S. mortality rates. Provide a 95% CI for the expected...
-
Use the contingency-table method to perform the test in Problem 13.1? Gynecology In a 1985 study of the relationship between contraceptive use and infertility, 89 of 283 infertile women, compared...
-
What nonparametric test could be used to test for the effect of linoleic acid on SBP? Hypertension Polyunsaturated fatty acids in the diet favorably affect several risk factors for cardiovascular...
-
Role of controller, role of chief financial officer. George Jimenez is the controller at Balkin Electronics, a manufacturer of devices for the computer industry. The company may promote him to chief...
-
In the following, assume that all growth and discount rates are stated in real terms. 1. Assume the Eurozone inflation-adjusted average growth in capital stock is 3.0 percent per annum into...
-
Which conclusion presented by Ryan about the top-down approach and the bottom-up approach is most likely correct? A. Conclusion 1. B. Conclusion 2. C. Conclusion 3. Use the following information to...
Study smarter with the SolutionInn App