Statististics Technology assignments weeks 1-7

Week7techassignment.docx

Home >Business & Finance homework help >Accounting homework help >Statististics Technology assignments weeks 1-7

Statistics Technology assignment

WEEK 7:

Test for Correlation - Download the data set “Course Evaluations” in your preferred technology format (StatCrunch, Statdisk, Excel). Column 2 denotes the mean course rating, and Column 3 denotes the mean professor rating. Using your preferred technology format (StatCrunch, Statdisk, Excel), generate a scatterplot for these two data sets. Based on the graph, do you believe the two sets are correlated?

Now, using the same program, complete a hypothesis test to test the claim that the course rating and the professor rating are correlated. Provide a printout of your technology output using the Insert/Edit Image feature (no attachments!) Explain your conclusion in statistical and non-statistical terms and how you arrived at that conclusion. Be sure to follow the 8-step procedure on page 360, using technology to do your calculations. You should include your null and alternative hypothesis (in English and in symbolic form), your significance level, whether you are conducting a right tailed, left tailed, or two tailed test, r-value, p-value, and conclusions.

PROFCOURSE EVALPROF EVALPROF GENDERPROF AGESIZEPROF BEAUTYPROF PHOTOCLASS LEVEL

14.34.7female36245.000colorupper

24.54.6male59173.000colorupper

33.74.1male51553.333colorupper

44.34.5female40403.167colorupper

54.44.8female31427.333colorupper

64.24.4male621825.500colorupper

74.04.4female33334.167colorupper

83.43.4female51254.000colorupper

94.74.8female33294.667colorupper

103.94.0male47165.500colorupper

113.13.6male35184.833colorupper

124.04.1male37304.333colorupper

133.84.1male42284.833colorupper

143.43.5male49304.000colorupper

152.92.9female37235.500colorupper

164.54.6male45234.167colorupper

174.04.4female56272.500colorupper

183.84.0male481004.333colorlower

194.34.9female46254.333black&whiteupper

203.43.5female57174.333colorupper

213.43.7female52194.833colorupper

223.33.4female29192.833colorupper

234.34.3male62303.000colorupper

244.44.5male64154.167colorupper

244.14.3male64214.167colorupper

254.64.8female34207.833colorupper

264.24.4male58843.833colorupper

274.04.4male52134.833colorupper

283.33.6male73123.000colorupper

294.44.6male70473.000colorupper

302.32.3female41105.167colorupper

313.54.3male63284.333colorupper

324.74.9male47102.667colorupper

333.94.2male39865.500colorlower

344.04.2female47214.333colorlower

354.34.3male54152.333colorupper

363.83.9female44306.500colorupper

373.83.9male47202.333colorupper

384.04.1male62123.000colorupper

394.64.8male60253.667colorupper

403.53.3male37156.167colorupper

414.74.4male42134.000colorupper

433.43.3female39228.167colorlower

443.94.0male49286.500colorupper

454.54.5male61224.833colorlower

464.74.9male33307.000colorupper

473.53.7female58264.667black&whiteupper

483.73.9female56123.833colorupper

494.04.4female50223.167colorlower

504.14.4male52573.167colorupper

514.44.5female33105.833black&whiteupper

524.24.3male57695.667black&whiteupper

534.54.8female38466.500black&whiteupper

543.84.1female34541.667colorlower

553.13.5male34246.667colorupper

563.74.0male32853.667black&whitelower

573.93.8female42446.167colorlower

584.04.1female43353.333colorlower

593.33.7male35113.667black&whiteupper

603.13.2female62223.500colorupper

614.04.2male42452.667colorupper

624.34.5male39225.667colorupper

633.73.8female52646.000black&whiteupper

643.43.7female52316.500black&whiteupper

654.34.5female52592.333colorupper

663.73.8male6492.333colorupper

674.24.5male50157.167colorupper

682.22.4male60231.667colorupper

693.03.0female51475.167colorupper

704.34.5male43193.500colorlower

723.53.5male52465.833colorupper

734.64.8male513486.167colorlower

743.74.2male38443.333colorlower

753.84.0female47195.167colorlower

763.63.7female43474.167colorlower

774.44.5female38332.500colorlower

784.14.7male43104.333colorlower

794.34.3male5773.000colorupper

804.04.0female5196.333colorupper

814.84.9male45133.333colorlower

823.53.5male57132.833black&whitelower

833.63.3female47166.667black&whitelower

843.84.2female54186.833black&whitelower

854.74.8male58167.833black&whitelower

864.94.9male42157.833black&whitelower

874.34.5male33855.833colorlower

883.33.3male62112.000colorlower

893.43.3female35607.833colorlower

903.63.6male61273.333colorlower

914.04.1female52614.500colorlower

923.93.7female60234.333black&whiteupper

934.34.5male32986.833colorlower

943.33.5female42485.333colorupper