Use the data provided to perform a single sample Z test in Excel.

Data description: This data measures the number of aphids per wheat plant, 7 days after intentional infestation, to determine if the novel plant variety, which contains a higher concentration of leaf phenols than standard varieties, is more or less susceptible to aphid feeding than a standard variety you typically use for greenhouse studies. You measured the number of aphids on 40 individually caged plants, selected at random from a pool of several hundred plants. Previous measurements using the 'standard' wheat variety found that the average number of aphids after 7 days was 82 per plant with a standard deviation of 20.

In your assignment submission, you must provide the following information in a clear and organized manner: 1. Your null and alternate hypothesis stated in the context of the study (two-sided) 2. The population mean and standard deviation 3. The mean, standard deviation and sample size for the sample data 4. A histogram of the sample data 5. A boxplot of the sample data 6. A normal Q-Q plot of the sample data 7. A statement on whether or not the sample data meets the assumptions, and why you drew this conclusion 8. (And if the data meets the assumptions) The Z statistic and p value (two-sided, = 0.05) obtained by the test as part of a sentence interpreting the results of the analysis

number_aphids

73

80

72

77

84

85

53

58

64

64

79

84

62

56

93

69

61

82

62

92

92

97

117

72

63

74

102

101

101

77

86

90

73

71

68

81

72

90

88

86