INSTRUCTIONS:
After downloading the Lab 1 spreadsheet, save the file to your Desktop or a folder you can easily navigate to. You will add information to this file, so be sure to save it periodically. Upon completion, upload the file to the Lab 1 Assignment Dropbox.
Note the tabs at the bottom of the screen:
Open the Worked Example tab. You will find a small data set followed by descriptive statistics computed using Excel statistical functions. If you haven't used Excel, you may need to search the Internet for Excel tutorials or use the Help features. Pay particular attention to how spans of rows and columns are represented in Excel. You will also find instructions for creating the scatterplot and trendline.
Next, open the Data & Analysis tab. You will find a data set of 84 cases. one column represents thickness and the other represents internal temperature. Data are followed by a blank table of statistical terms. Following the worked example, you will complete the numerical analysis for each type of statistical element (N, mean, median, etc.). You will need to use the Critical Values Table to determine wether the obtained r is signficant.
After completing the data analysis, open the Report tab and respond all 13 items in the adjacent spaces.
Upon completion of this lab, save the file and upload it into the Lab 1 Assignment Dropbox.
The worked example is also computed using SPSS. Open the SPSS tab and compare the values highlighted in red with those from the worked example using Excel. Can you match them up?
Document Preview:
Critical Values Table SPSS Report Data & Analysis Worked Example Instructions Temp N Mean SD r coefficient Report the extent to which assumptions were met. Relationship between two ratio level variables Responses Questions PEARSON(data list 1,data list 2) RSQ(data list 1,data list 2) r-squared Min Max Median Mode COUNT(data list 1) AVERAGE(data list 1) STDDEV(data list 1) MIN(data lsit 1) MAX(data list 1) MEDIAN(data list 1) MODE(data list 1) Scatterplot Highlight data Select Chart Wizard Select X-Y (Scatter) then Finish Add a trend line: COUNT(data list) AVERAGE(data list) STDEVA(data list) MIN(data list) MAX(data list) MEDIAN(data list) MODE(data list) RSQ(data list X, data list Y) PEARSON(data list X, data list Y) Thickness df (N-2) alpha=0,05 Critical value for Pearson r ? Worked example Select Linear, then OK Justify descriptive statistics appropriate for correlation. Characterize the types of variables and measures required under correlation. State the appropriate research hypothesis. Explain assumptions under correlation. Justify the sample size needed to detect a significant correlation. Discuss the degree to which a causal inference can be inferred from this analysis. Evaluate the costs and benefits of this statistical technique. Compare r coefficient to this value. risk credit place scatterplot here Since r= 0.97 is greater than 0.88, conclude r is significant. Correlations risk Pearson Correlation Sig. (2-tailed) N Model Summary R R Square Adjusted R Square Std. Error of the Estimate ANOVAb Sum of Squares df Mean Square F Sig. Regression Residual Total Coefficientsa Unstandardized Coefficients Standardized Coefficients t B Std. Error Beta (Constant) ** Correlation is significant at the p=0.01 level (two-tailed) risk credit 0.969** Filliben, J. J.(1975). The Probability Plot Correlation Coefficient Test for Normality, Technometrics,17, 1, pp. 111-117. HOW TO...