i need help calculating a statistical analysis of my data. I don't need it put into a graph, but i just need help with the calculations please. ignore where it says refer to figure 4.

45 (adapt the table as needed based on the data). b. A statistical analysis of your data (2 marks): Calculate summary statistics in the form of a sample mean (average), standard deviation (SD), standard error of the mean (SE) and 95% confidence intervals (CI) using Microsoft Excel. Include these data in the table described under point (a) above. The descriptive statistics are summarized in the flow chart shown in figure 4 and they are explained on pages 28-30. C. Average curdling time and cheese weight graphs (5 marks total): Label your x- and y-axes appropriately based on the data collected. Two senStatistical analyses of data Mean (x) Standard Deviation Standard Error 95% Confidence The average of your (SD) (SE) Interval (CI) data points. Calculated An indication of how data Measures the Calculated using the SE by taking the sum of are spread around the accuracy with no value. It is your data ([ x;) and mean. This is also known as which a sample approximately double dividing by the number variability represents a the SE value and of data points (n). Example: Using the same population. extends above and X = Ex; values as shown for the To calculate SE you below the mean. Cl is n mean: must know the SD wider than the SE and Example: The heights of of the mean. provides a 95% chance plants (cm) after 30 Example: that true population SD = 2 (x, - x) 2 days of growth at 22 C n - 1 on of values yo mean would fall within SE = SD this range. Height 1 Height 2 Height 3 Height 4 SD = (3.0-2.6) + (2.6-2.6)2 + (3.2-2.6)+ (1,6-2.6) 3.0 2.6 3.2 1.6 4-1 n Example: SD = 0.40)2 + (0.00)2 + (0.60)2 + (1.00)2 SE = 0.71 CI = SE X 2 x = 3.0 + 2.6+ 3.2+1.6 4 - 1 CI = 0.35 x 2 SD = 0.16 + 0.00 + 0.36 + 1.00 CI = +0.7 SE = 0.71 x = 10.4 SD = 1.52 2 4 SE = 0.35 x = 2.6 SD = V 0.51 SD = 0.71 TenONISb Interpretation of data obtained via statistical analyses After running statistical analyses, you now proceed to observe trends within and between the different treatments. These data can tell you how the treatments may have affected the process being studio( before microwave ) ciate Trial 10 ke to (min : sec ) gon Groups Curdling time / initial curd weight Final weight bot 1:30 20. 55 9 19.30 9 4: 10 34. 45 9 19.88 9 2:32 28 . 329 24.06 ai 3:50 22 . 3 4 9 19 . 53 8:26 24. 75 9 20.75 9 3 min 32. 639 18.96 0 3 min 26: 50 9 20 08 Q 1: 30 22 . 59 9 20. 290 3 min 28.70 9 22. 129 NOTE: 0.52m Citric acid PHE 1. 74 Milk PHS before 6 . 75 after microwave Afters . 80 Trial 2 :Irial 2 : Groups curdling time initial weight Final weight 6 min 20.15 g 17. 309 8 min 53 sec 29. 55 g 20.75 9 7 7 31 .79 9 21. 40 9 9:40 26- 23 9 19. 61 9: 27 25. 4 19. 3 3 op 7:25 31. 75 17.48 7:30 35. 68 20. 38 19. 55 14.25 9 min 35. 78 23. 42\f