11.44YESRange does not contain 021.91YESRange does not contain 032.13YESRange does not contain 042.29YESRange does not contain 055.48YESRange does not contain 026.87YESRange does not contain 023.87YESRange does not contain 034.15YESRange does not contain 047.24YESRange does not contain 0DifferenceSignificant?

14.04YESRange does not contain 024.37YESRange does not contain 037.43YESRange does not contain 014.15YESRange does not contain 027.21YESRange does not contain 015.63YESRange does not contain 01.1408451E-22 CHISQ.TEST(L62:Q63, L66:Q68)Use Cell K54 for the Excel test outcome location.Place the actual distribution in the table below.ABCDis <0.05Male7532Female822315755Place the expected distribution in the table below.ABCDMale7.51.40.60.4Female7.50.560.40.6qually across.ctices are gender specific or related to education levels.e not sufficient enough to provide any answers on the pay scale between men and women.the alpha.pattern across the salary grades?

Data Input Table:Salary RanGroup name:ABCList salaries within each grade23.326.541.624.334.840.622.635.545.523.735.742.623.728.341.224.427.322.937.224.923.822.723.323.522.823.623.1P-valueF crit1.2202E-352.42704

EF5325732512650EF1.20.361.680.36

nge GroupsSalaryGradeDegreeGradeDEF23.3A0A48.158.77424.3A0A53.666.777.122.6A0A57.566.774.223.7A0A49.663.675.223.7A0A53.862.779.724.4A0A5676.222.9A0A61.324.9A1A64.623.8A1A69.522.7A1A6723.3A1A59.923.5A1A64.822.8A1A23.6A1A23.1A1A26.5B0B34.8B0B35.5B0B35.7B0B28.3B0B27.3B1B37.2B1B41.6C0C40.6C0C0C45.5C1C42.6C1C41.2C0D48.1D0D53.6D1D57.5D1D49.6D1D53.8D0E58.7E0E66.7E0E0E63.6E0E62.7E1E56E1E61.3E1E1E

69.5E1E67E1E59.9E1E0F74F0F77.1F0F1F75.2F1F79.7F1F76.2F

Week 4: Identifying relationships - correlations and regressionTo Ensure full credit for each question, you need to show how you got your results.This inor showing the excel formula in each cell.Be sure to copy the appropriate data1What is the correlation between and among the interval/ratio level variables witha. Create the correlation table.i.What is the data input ranged used for this question:ii. Create a correlation table in cell K08.b. Technically, we should perform a hypothesis testing on each correlation to deteif it is significant or not.However, we can be faithful to the process and save somtime by finding the minimum correlation that would result in a two tail rejection oWe can then compare each correlation to this value, and those exceeding it (in eithpositive or negative direction) can be considered statistically significant.i. What is the t-value we would use to cut off the two tails?

Get answer to your question and much more

ii. What is the associated correlation value related to this t-value?r =

c. What variable(s) is(are) significantly correlated to salary?d. Are there any surprises - correlations you though would be significant and are n

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 17 pages?

Upload your study docs or become a

Course Hero member to access this document

Term

Spring

Professor

WILLIAMS

Tags

Statistical hypothesis testing