I need help with crrelation correlation assignment that is attached. Thank you i

Question

I need help with crrelation correlation assignment that is attached. Thank you in advance for any assistance.

Correlation Coefficient Homework

http://www.mathportal.org/calculators/statistics-calculator/correlation-and-regression-calculator.php

(Don’t forget to highlight the radio button to find the correlation coefficient)

Again, use your store data.

Look at the four categories below (2-5). Take a guess at which two variables will yield the highest correlation coefficient. Put an answer here. Just guess.

Identify the correlation coefficient for the following (use your store data sheet):

2. Traffic and Transaction

3. Transaction and OppVol

4. UPT and Traffic

5. OppVol and UPT

The store data is below:

Name Gender Sales Transactions Traffic UPT OppVol I. McClean m 1526 50 130 5.82 618 Z. Terrell f 1382 51 100 6.22 25 A. Leaderis m 1701 55 111 6.02 784 S. Teagle f 1573 60 117 5.56 456 J. Brown f 2144 62 103 5.64 31 P. Worlda f 1357 67 130 6.22 159 V. Totalier m 2352 71 117 5.56 874 L. Wheeler m 2113 76 130 5.64 32 S. Miller f 2579 77 216 6.02 951 M. Mayo f 2533 82 186 5.69 30 C. McMillion f 2113 88 162 5.8 173 J. Dixon f 2441 96 182 6.03 1050 M. Scott m 2795 109 216 5.64 1316 E. Browning f 1699 55 93 6.52 34 M. Davis f 2311 81 93 6.28 52 B. Wilson m 2255 55 91 7.03 64 M. Merrill f 1657 57 103 6.33 102 R. Haug f 1756 72 186 6.81 132 L. Thompson m 1966 70 216 6.28 147 D. Arias m 2211 101 186 6.33 257 S. Reda m 1652 95 111 6.62 258 M. Clarke f 1095 104 182 6.51 259 T. Hags f 1107 69 182 6.71 357 L. Endsoy m 2552 86 162 6.43 861 J. Santiago m 1283 105 162 7.03 895 UPT - Units per transaction OppVol - Missed Sales based on volume

Explanation / Answer

we can use software like R, Minitab , etc

I use Excel

go to Data- data analysis - correaltion

and select all columns

2. Traffic and Transaction = 0.5957

3. Transaction and OppVol= 0.39569

4. UPT and Traffic = -0.0188494

5. OppVol and UPT = -0.1882704

Please rate

Sales Transactions Traffic UPT OppVol Sales 1 Transactions 0.264489133 1 Traffic 0.256127484 0.59573101 1 UPT -0.417537777 0.08986526 -0.0188494 1 OppVol 0.320949741 0.39569902 0.4127525 -0.1882704 1

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

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