What is the STEP-by-STEP guide to using EXCEL or StatCrunch technology or by han

Question

What is the STEP-by-STEP guide to using EXCEL or StatCrunch technology or by hand equation to find t-STAT?

provides the cellphone rating of Company X and Company Y in 23 cities.

68.7

66.9

Company X and Company Y?

The accompanying data table

provides the cellphone rating of Company X and Company Y in 23 cities.

City Company X Company Y City 1 62.4 73.2 City 2 64.1 73.5 City 3 63.7 66.3 City 4 62.2 72.3 City 5 69 71.3 City 6 61.4 72.4 City 7 68.5 70.3 City 8 63.9 72.7 City 9 69 75.4 City 10 61.8 68.1 City 11 67.9 75.3 City 12 73.7 67.6 City 13 65.9 72.4 City 14 64.5 70.7 City 15 65.9 68.9 City 16 67.8 75 City 17 64.5 73.3 City 18 63.4 73.6 City 19 58.3 72.9 City 20 64 66.9 City 21 67.9 72.6 City 22 70.9 68 City 23

68.7

66.9

Explanation / Answer

Note:- I am not able to write formula as i am not used to this. so i am providing link so, go and check formula for t-stat there. and complete your answer.

http://psc.dss.ucdavis.edu/sommerb/sommerdemo/stat_inf/tutorials/tcorrhand.htm

now, following is the link for 0.05 level of significance,

http://psc.dss.ucdavis.edu/sommerb/sommerdemo/stat_inf/tutorials/critvalues_t.htm

City Co. X Co. Y d d2 city 1 62.4 73.2 -10.8 116.4 city 2 64.1 73.5 -9.4 88.36 city 3 63.7 66.3 -2.6 6.76 city 4 62.2 72.3 -10.1 102.01 city 5 69 71.3 -2.3 5.29 city 6 61.4 72.4 -11 121 city 7 68.5 70.3 -1.8 3.24 city8 63.9 72.7 -8.8 77.44 city 9 69 75.4 -6.4 40.96 city 10 61.8 68.1 -6.3 39.69 city 11 67.9 75.3 -7.4 54.76 city 12 73.7 67.6 6.1 37.21 city 13 65.9 72.4 -6.5 42.25 city 14 64.5 70.7 -6.2 38.44 city 15 65.9 68.9 -3 9 city 16 67.8 75 -7.2 51.84 city 17 64.5 73.3 -8.8 77.44 city 18 63.4 73.6 -10.2 104.04 city 19 58.3 72.9 -14.6 213.16 city 20 64 66.9 -2.9 8.41 city 21 67.9 72.6 -4.7 22.09 city 22 70.9 68 2.9 8.41 city 23 68.7 66.9 1.8 3.24 -130.2 1271.44

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.