Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please help with this question 1. Stats Sheet: Table shows a sample of the student marks - use the correct functions or the labeled cells

image text in transcribed

image text in transcribed

image text in transcribed

please help with this question

1. Stats Sheet: Table shows a sample of the student marks - use the correct functions or the labeled cells (Max, size, Average, Std Dev, Variation, Correlation etc) 4 marks 2 Table shows a sample of the student marks- use the correct functions below Days Absent 2 10 6 0 Max Test Mark Sample Size Average Mark 2 9 1 Marks Standard Deviation Variance Marks Correlation: Marks vs Days abser Studen Marks 3 t ID 4 1075 844 5 1912 101 6 4196 555 7 4483 815 8 6237 770 9 6284 177 10 6285 824 11 6312 844 12 6353 98 13 6747 501 14 6778 566 15 7025 782 16 7284 230 17 846 18 7717 600 19 7788 800 20 8362 500 21 8843 800 22 9573 532 23 9849 788 Marks School City # Bramptoj 24 Bramptor 24 Brampton 24 Bramptor 24 Bramptos 24 Bramptor 24 Bramptor 24 Brampton 24 Bramptot 24 Brampton 26 Bramptor 26 Bramptot 26 Bramptor 26 Bramptor 26 Brampton 25 Brampton 26 Bramptor 26 Brampton 26 Brampto! 26 Bramptor 26 2 10 6 5 2 9 7486 0 1 3 6 0 3 0 3 X B D E F G . 9849 788 26 0 1 783 55 3 688 55 3 55 3 737 144 7 55 10 3 800 55 2 566 55 6 765 56 3 1 222 56 7 2 255 56 8 3 5 1625 2309 2513 2834 4470 5713 6695 7224 7670 7718 7825 8049 9410 2137 2877 3817 4562 4938 5701 6035 6076 6141 544 715 799 Bramptor Rexdale Rexdale Rexdale Rexdale Rexdale Rexdale Rexdale Rexdale Rexdale Rexdale Rexdale Rexdale Rexdale Mississau Mississau Mississau Mississau Mississau Mississau Mississau Mississau Mississau 56 56 0 5 0 6 222 56 56 83 8 4 7 8 702 700 5 -9 10 0 800 321 187 1 83 83 83 83 83 83 3. 31 2 13 222 9 5 44 322 665 165 84 5 15 84 9 46 Stats Pivot Table Match & Index Corr Calculate Type here to search

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Finance questions