In Units 5 and 6, we will learn about statistics used to analyze data. For this assignment, you will calculate descriptive statistics and a correlation using a sample data set. You will need to use EXCEL data analysis to conduct statistics. Please upload the data analysis toolpak onto your computer.

In Units 5 and 6, we will learn about statistics used to analyze data. For this assignment, you will calculate descriptive statistics and a correlation using a sample data set. You will need to use EXCEL data analysis to conduct statistics. Please upload the data analysis toolpak onto your computer.

Directions to upload EXCEL Data analysis:

Go to EXCEL

Click on File

Click on options

Click on Add-Ins

Click on Analysis T ool Pak

Click Go

Check Analysis T ool Pak

Click OK

Data Analysis should appear on the upper right of your toolbar.

Directions for Descriptive Statistics (mean, median, standard deviation, variance, etc) in EXCEL:

Go to Data

Go to Data Analysis

Descriptive Statistics

Input Range (Select Data Column)

Click Output Range (Select area of cells for statistics to appear)

Check () Summary Statistics

Directions for Correlation Coefficient EXCEL

Go to Data

Go to Data Analysis

Correlation

Input Range [Select 2 columns (A & B =2 variables: hrs studied, grade score)]

Output Range: Select cells for correlation statistic to appear OK

Directions for Graphing your Correlational Data - To Create Graph (Line Plot):

Regression Analysis:

Data

Data Analysis

Regression

Input range X (Variable 1)

Input range Y (Variable 2)

Select output range (select area of cells for graph to appear)

Line Fit Plots:

OK

Add Title, Label Axis, and Figure Legend below graph describing what graph is

showing.

Instructions:

Upload the Excel Data Analysis Program onto your computer. For the data set below, please

provide:

the mean and standard deviation for the number of hours studied. (10 points)

the mean and the standard deviation for test score. (10 points)

the correlation between the number of hours studied and the obtained test score. (30

points)

Graphofcorrelationaldata(30points)

What conclusion can you draw from these results? (20 points)

Test Score

1.100 2.90 3.20 4.52 5.83 6.76 7.55 8.98 9.89 10.70

Hours Studied

4 4 1 2 3 2 1 4 4 2