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 Tool Pak Click Go Check Analysis Tool 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 Axi

Instructions: Upload the Excel Data Analysis Program onto your computer. For the data set below, please provide: 1. the mean and standard deviation for the number of hours studied. 2. the mean and the standard deviation for test score. 3. the correlation between the number of hours studied and the obtained test score. 4. Graph of correlational data 5. What conclusion can you draw from these results?

Test Score Hours Studied 100 4 90 4 20 1 52 2 83 3 76 2

55 1 98 4 89 4

70 2