Writing Assignment Description

For this writing assignment, you are required to analyze a given dataset, apply statistical

concepts you learned in this class, and present your results in an effective and professional

manner.

• It is due on May 22, 2019 by 11:59 p.m. There will be absolutely no extensions to this

deadline, and late assignments will not be accepted.

• You will submit two files for this assignment:

1. An Excel file that contains your calculation.

2. A Word file that contains your results, and interpretations.

• Put your full name, course name, semester, and “Writing Assignment: the name of your

data file” at the top of the first page.

• Use font: Times New Roman, size: 12 pts, and spacing: 1.5.

• When answering each question, number each one followed by your excel results, and

interpretation. Position your tables, graphs, and charts in an organized way. Graphs

should have proper titles, axis labels, legends (if applicable) and should be easy to read.

• This file must NOT exceed 3 pages.

• Name your word file as “Lastname Firstname Result 221”.

• Show all your calculations. You can use different worksheets in the same Excel file.

• Name your file as “Lastname Firstname Calculation 221”.

Using the dataset, answer the following questions:

1. Find the mean, median, sample variance and sample standard deviation for the variables

5-year comp and age.

2. Create a histogram using Excel’s Data Analysis toolpack for 5-year comp. Use the

Sturges’ rule to find how many bins you should include. In your Word file, make sure to

include both a frequency table for the histogram with bin limits, frequencies and relative

frequencies, and your histogram chart. What can you say about the distribution of 5-

year comp?

3. Do a scatterplot with X = Age and Y = 5-year comp. Interpret the plot.

4. Find the covariance and correlation coefficient between age and 5-year comp. Explain

what these statistics mean for your dataset.

5. Conduct a hypothesis test at 5% significance level that the population mean of 5-year

comp is \$45,000:

(a) Assume that the dataset given is a sample and population standard deviation is

unknown.

6. Calculate the confidence interval for population mean of 5-year comp for 90%, 95%,

and 99% confidence levels:

(a) Assume that the dataset given is a sample and population standard deviation is

unknown.

7. Can you reject the hypothesis that population mean of 5-year comp is \$45,000 in both

questions 5a and 6a?