Homework: Descriptive Statistics
In this homework, you will be provided a fictitious study.
A. Instructions on how to add the Data Analysis ToolPak to Microsoft Excel.
B. Download the study.
C. Look at the variable values and read the descriptions of the variables. Which values appear to be unrealistic?
D. Do these values have anything in common?
E. Use Microsoft Excel to obtain the descriptive statistics.
a. Save the Microsoft Excel workbook to a file and submit it with the final document. Eliminate the unrealistic values from the analysis by deleting the data for those values.
b. Why do you think these values are unrealistic?
c. Run the descriptive statistics again and then write a statement on what the eliminated values had in common. Would it be acceptable to eliminate these values from the study you would like to publish?
Format your homework according to the following formatting requirements:
o The answer should be typed, using Times New Roman font (size 12), double spaced, with one-inch margins on all sides.
o The response also includes a cover page containing the title of the homework, the student's name, the course title, and the date. The cover page is not included in the required page length.
o Also include a reference page. The Citations and references must follow APA format. The reference page is not included in the required page length.
Attachment:- Install-Analysis-Tool-Pak.rar