A. DATA FOR: Pupal Mass Sample Mass (g) Development Time (Days) 1 0.688 65 Frequency Distribution of Development Time 0.688 66 Frequency Distribution of Pupal Mass (g) 20 0.658 64 4 0.60 66 10 0.612 60 15 0.625 59 0.685 59 10 0.682 59 10 11 0.680 50 12 10 0.680 62 13 11 0.602 70 14 12 0.828 71 15 13 0.805 70 16 14 0.888 72 55.00 59.00 63.00 67.00 71.00 75.00 17 15 0.805 64 0.60 0.66 0.72 0.78 0.84 0.90 Development Time (Days) 18 15 0.822 64 19 16 0.601 64 Pupal Mass (g) 20 18 0.766 64 21 19 0.772 65 22 0.755 65 Development Time (Days) vs. Mass (g) 20 23 21 0.758 65 80 24 22 0.743 65 25 23 0.708 65 .... 26 24 0.773 65 27 25 0.773 65 28 25 0.771 65 40 29 26 0.69 66 30 28 0.805 66 20 31 29 0.885 66 32 30 0.801 66 33 0.65 0.7 0.75 0.8 0.85 34 Па mean =AVERAGE(range) Mass (g) 35 konba 26 24 0.773 65 27 25 0.773 65 28 25 0.771 65 29 26 0.60 66 30 28 0.805 66 31 29 0.885 66 30 0.801 66 33 34 п3 mean =AVERAGE(range) median =MEDIAN(range) mode =MODE(range) standard deviation =STDEV(range) variance =VAR(range) coefficient of variation (SD/mean) 35 36 37 39 40 covariance =COVAR(range 1, range 2) correlation coefficient =CORREL(range 1, range 2) 41 43
Attached is the dataset:
17) Looking at the graph on Pupal Mass vs Development Time, what type of graph is this? (pie chart, column chart, bar chart, histogram, line graph,
18) Using the appropriate formula, calculate the
19) Is the covariance positive, negative or zero? .
20) Are the variables dependent on one another? (yes, no)
21) Using the appropriate formula, calculate the
22) Is the correlation positive, negative or zero?
23) The null hypothesis was that development time has no effect on pupal mass. More stats need to be done, but based on the data collected so far, does it appear that they will reject the null? (yes or no)
24) Which program did you use for your calculations? (Excel or Sheets)
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 6 images