Learning Goal: I’m working on a statistics exercise and need a sample draft to h

Learning Goal: I’m working on a statistics exercise and need a sample draft to help me learn.QUESTION 1: FREQUENCY TABLES (10 MARKS)
Organize the ratio scores below in a table showing simple frequency, relative frequency, and cumulative frequency. Make use of sensible categories to categorize data.
49 52 47 52 52 47 49 47 50
51 50 49 50 50 50 53 51 49
30 55 32 56 47 39 41 31 42
36 40 45 31 41 36 50 42 33
36 39 42 37 40 39 50 31 49
QUESTION 2: FREQUENCY TABLES (10 MARKS)
Organize the data in a table with simple frequency, relative frequency, cumulative frequency and relative cumulative frequency.
18 19 18 20 21 18 19 20
21 18 19 18 20 20 18 19
20 18 19 18 18 19 22 18
17 18 20 19 20 19 18 19
22 18 17 18 21 19 21 22
19 19 18 29 17 18 19 18
QUESTION 3: MEAN, MEDIAN AND MODE (5 MARKS)
For the below data asset, calculate the:
a.) Mean
b.) Mode
c.) Median
55 57 59 58 60 57 56 58 61 58 59
QUESTION 4: PERCENTILE & QUARTILES (10 MARKS)
For the given data set below, calculate the 25th, 50th and 75th percentile. Also provide the Five Number Summary.
10 11 11 11 12 12 13 15 16 16 16 17 18 19 19 19 24 25 25 25
QUESTION 5: MEAN MEDIAN AND MODE (10 MARKS)
A frozen food company has a contract with Farm A, to provide peas for their processing plant. The daily supply of peas (in tons) over the past two weeks from Farm A has
been as follows:
357.38 262.8 319.95 412.9 398.46
330.33 329.33 332.04 309.42 229.88
259.43 337.99 383.91 341.27 319.85
The frozen food company also contracts with Farm B. The daily supply of peas (in tons) over the past two weeks from Farm B has been as follows:
364.32 295.18 352.92 420.14 314.39
143.87 421.43 291.21 306.03 348.88
333.81 191.99 324.79 315.25 435.26
5.1 CALCULATE THE RESPECTIVE MEAN, MEDIAN AND STANDARD DEVIATION FOR EACH OF THE FARMS. (3 MARKS)
5.2. ALSO, COMMENT AND INTERPRET ON THE CALCULATIONS PROVIDED AND WHAT THESE VALUES SHOW FOR EACH FARM. (3 MARKS)
5.3. WHICH FARM WOULD YOU PREFER WORKING WITH IF YOU WERE THE FROZEN FOOD COMPANY AND WHY? (4 MARKS)
QUESTION 6: THEORY (10 MARKS)
6.1. EXPLAIN THE DIFFERENCE BETWEEN A POPULATION AND A SAMPLE AND GIVE AN EXAMPLE OF EACH (2 MARKS)
6.2. EXPLAIN THE DIFFERENCE BETWEEN A PARAMETER AND A STATISTIC AND GIVE AN EXAMPLE OF EACH (2 MARKS)
6.3. DISCUSS THE REASONS FOR WHY WE MAKE USE OF SAMPLING DATA (3 MARKS)
6.4. DISCUSS TWO CHARACTERISTICS OF THE NORMAL DISTRIBUTION (3 MARKS)
QUESTION 7: SCATTERPLOTS & CORRELATION (10 MARKS)
Discuss and comment on each of the below graphs in terms of its correlation and relationship.
7.1
7.2
7.3
QUESTION 8: CORRELATION (5 MARKS)
8.1. DISCUSS THE DEFINITION OF CORRELATION AND WHAT INFORMATION THE CORRELATION CALCULATION PROVIDES (3 MARKS)
8.2. DISCUSS THE LIMITS OF CORRELATION (TIP: BETWEEN WHAT VALUES CAN THE CORRELATION BE) (2 MARKS)
QUESTION 9: CORRELATION
The number of visitors to a cycle track and the number of drinks sold by a café at the location are recorded in the table below.
Monday Tuesday Wednesday Thursday Friday Saturday Sunday
Number of
Visitors
32 45 39 43 58 84 65
Drinks Sold 17 20 23 7 24 49 38
9.1. DRAW A SCATTERPLOT DIAGRAM AND INTERPRET THE GRAPH (4 MARKS)
9.2. DESCRIBE THE RELATIONSHIP BETWEEN THE NUMBER OF VISITORS AND THE NUMBER OF DRINKS SOLD. (4 MARKS)
9.3. WHICH PARTICULAR DAY DOES NOT FIT THE RELATIONSHIP? (4 MARKS)
9.4. CALCULATE THE CORRELATION COEFFICIENT (3 MARKS)
QUESTION 10: NORMAL DISTRIBUTION (15 MARKS)
The heights of adult females are normally distributed with mean 160cm and Standard Deviation 8cm.
10.1. EXPLAIN THE NORMAL DISTRIBUTION AND STANDARD NORMAL DISTRIBUTION IN YOUR OWN WORDS (4 MARKS)
10.2. FIND THE PROBABILITY THAT A RANDOMLY SELECTED ADULT FEMALE HAS A HEIGHT GREATER THAN 170CM (3 MARKS)
10.3. FIND THE PROBABILITY THAT A RANDOMLY SELECTED ADULT FEMALE HAS A HEIGHT GREATER THAN 180CM (3 MARKS)
10.4. HALF OF TALL ADULT FEMALES HAVE A HEIGHT GREATER THAN H CM. FIND THE VALUE OF H. (5 MARKS)
Requirements: 10 question in exel   |   .xls file