Reference no: EM13911716
Assignment: Using Descriptive Statistics
In the news, we are constantly bombarded by statistics such as unemployment rates, stock market swings, or changes in the housing market. A vast majority of the statistical information presented to us is in the form of descriptive statistics. In descriptive statistics, a sample is taken, and values such as mean, median, mode, standard deviation, and variance are determined. These values are used to compare to other samples or are used as a measure of the current state of a population. The use of descriptive statistics is a common practice in the decision-making process in many professional fields.
In this assignment, you will use descriptive statistics to make an informed decision-in this case, to decide whether you are going to purchase a new car. Consider the following scenario:
The manufacturer claims that the Brillton EX gets 25 miles per gallon (MPG) in the city and 35 MPG on the highway. However, you are skeptical. You manage to retrieve data for the first Brillton EX models that were tested by a consumer protection agency. This data is available in the following spreadsheet.
This spreadsheet consists of several tabs:
• Samples: This tab contains all of the different samples tested. These are randomly selected Brillton EX cars. The MPG levels of these cars were measured in the city and on the highway.
• Descriptive Statistics: This tab contains the formulas that will calculate the mean, median, mode, standard deviation, and variance from the sample data.
• Population: This tab contains the mean, median, mode, standard deviation, and variance for the entire population of Brillton EX models.
Instructions:
• Download the Brillton EX spreadsheet.
• On the Samplestab, chose one of the data samples.
• Input the data from the sample you selected into the Sample Data columns on the Descriptive Statisticstab. When you are done, the spreadsheet will automatically determine the mean, median, mode, standard deviation, and variance for this sample.
Note: There is a tab labeled Exampleto show you how this should work if done properly.
• In your report, address the following:
• Report the sample name that you selected.
• Report the mean, median, mode, standard deviation, and variance that were calculated for your sample. What does each of these values represent with respect to your sample?
• Compare the descriptive statistics you calculated to the population statisticsreported. Were there differences? Why or why not?
• Do you think that the sample you picked was representative of the population? Explain your response.
• Do you think that using descriptive statistics is a reliable method for gathering data in order to make an informed decision?
• Based upon your analysis, do you accept the manufacturer's claim that the Brillton EX gets 25 MPG in the city and 35 MPG on the highway? Why or why not?
Attachment:- brillton spreadsheet.rar
|
Why bank regulators have outlawed leverage by banks
: Leverage magnifies losses associated with declines in asset values but not with gains in asset values. This asymmetry is why bank regulators have outlawed leverage by banks that benefit from FDIC insurance.
|
|
What is the amount of the last dividend paid
: Weisbro and Sons common stock sells for $32 a share and pays an annual dividend that increases by 4.2 percent annually. The market rate of return on this stock is 9.90 percent. What is the amount of the last dividend paid by Weisbro and Sons?
|
|
Calculated magnetic moment
: (a) What would be the calculated magnetic moment of [Ni(H2O)6]2+ ? (b) What kind of metals are extracted by electrometallurgy? Give an example.
|
|
Estimate the present value of tax benefits from depreciation
: Your Company is considering a new project that will require $1,030,000 of new equipment at the start of the project. The equipment will have a depreciable life of 9 years and will be depreciated to a book value of $305,500 using straight-line depreci..
|
|
Compare the descriptive statistics you calculated
: Compare the descriptive statistics you calculated to the population statisticsreported. Were there differences? Why or why not? Do you think that the sample you picked was representative of the population? Explain your response
|
|
Evaluate the proposed acquisition of a new special-purpose
: You have been asked by the president of your company to evaluate the proposed acquisition of a new special-purpose truck for $320,000. The truck falls into the MACRS 10-year class, and it will be sold after 10 years for $57,000. The firm's marginal t..
|
|
Loss of hydrochloric acid
: In the second step, phenol is coupled (at the para position) to the diazonium sal t with the loss of hydrochloric acid, to form a yellow- orange azo dye. draw a reaction scheme.
|
|
What is the required rate of return on the market
: Fiske Roofing Supplies' stock has a beta of 1.23, its required return is 10.25%, and the risk-free rate is 4.30%. What is the required rate of return on the market? (Hint: First find the market risk premium.)
|
|
What will be the after-tax cash flow of this sale
: Suppose you sell a fixed asset for $115,000 when it's book value is $135,000. If your company's marginal tax rate is 39%, what will be the effect on cash flows of this sale (i.e., what will be the after-tax cash flow of this sale)?
|