USING EXCEL

A) I need steps to know how to find the mean, stabdard deviation, also a box plot and a histogram & normal probability plotB) i need steps to know how to construct a 95% confidence level and using a scatter plot to compare between age and performed in ACT math & need equation provided.

200 : f 22 senior 21

201 : female 20 sophmore 20

THE 200 AND 201 ROW IS 21 AND 20 FOR MATH SCORES

Purpose This project is to help you apply concepts to real world, real data analysis. In the real-world computers do most of the hard work for statisticians. This project will help you understand how an informative decision is made using data analysis. After completing this project, you should be able to determine which statistical procedures are appropriate; use StatCrunch or Excel to carry out the procedures and interpret the output The Database of UVA (Excel file) students contains information on the undergraduate students at University of Virginia. This list contains the data for different Qualitative and Quantitative variable. Your project is to obtain the results based on the following questions using StatCrunch or Excel. Copy the StatCrunch or Excel results (graph plus answer) into summary document using the guidelines in section C. Data: The Data set is on the project page on canvas. Use StatCrunch (in Mylab Statistics) or Excel to obtain results for the following questions. Directions: A) Exploratory Data Analysis 1. Obtain the mean and standard deviation for ACT Math scores for each class level (freshmen, sophomores, juniors, seniors) and interpret the results 2. Obtain the five number summary of ACT Math score for each class levels. Do any of these class levels have outliers? 3. Construct a boxplot and use it to investigate the data for outliers 4. Construct a histogram, and normal probability plot (QQ Plot) for ACT Math score for each class level B) Inferential Statistics 1. Construct and interpret a 95% confidence interval for , for the mean ACT Math score for each class level. 2. Using regression analysis (hint, use scatter plot, r, r2), investigate if there is a relationship between Age and performance in ACT Math score provide an equation can be used to predict ACT math score based on age, Write a Summary and Findings of the Project C) Write-up Write a brief introduction of the project. o Interpret the mean, and standard deviation in context of the data given. o Compare the measures of center and comment on which measure of center would best describe the data given. o Comment on the shape of the distribution, which class level appears to be more approximately normal o Are there any outliers in the data? Include results of your investigation for outliers. Identify which class level has an outlier o Comment on your assessment of normality. SEX AGE CLASS F 22 Junior M 21 Senior F 22 Senior 21 Sophomore 22 Senior 21 Junior 20 Freshman 22 Senior 20 Sophomore 23 Junior 20 Sophomore 22 Senior 14 M 20 Sophomore 22 Senior 21 Senior 22 Senior 21 Junior 21 Senior 19 Sophomore 19 Sophomore 20 Freshman 22 Senior 23 Senior 23 Sophomore 19 Freshman 27 22 Senior 28 21 Senior 29 20 Freshman 30 21 Sophomore 24 Senior 31 32 M 23 Senior 33 F 19 Sophomore 2 34 5 a 7 SHEEHAN2287 8 F 9 F 10 M 11 F 12 F 13 15 18 19 20 21 23 33 16 F 17 24 M M 25 TI F MF LL FLF MFM FMMF M 26 M M M F F LL FM MATH 228 23 25 19 28 26 14 23 18 22 23 26 222222222222222 24 24 18 27 20 25 21 26 28 28 25 18 25 28 21 26 18 21 20 + 34 M 35 M 36 F 37 M 38 M 39 F 40 M 41 42 M 43 F 44 F 45 F 46 M 47 F 48 F 49 M 50 F 51 52 53 54 55 M 56 28283 284 u M 60 M 57 F 58 M 64 M 22 Senior 20 Junior 21 Junior 19 Freshman. 21 Senior 20 Junior 22 Junior 20 Sophomore 22 Junior 20 Freshman 23 Senior 59 M LL 61 F F 63 M F 65 M 66 M 19 Sophomore 18 Freshman 20 Junior 22 Senior 19 Sophomore 20 Sophomore 21 Senior 27 Senior 19 Sophomore 20 Sophomore 19 Sophomore 21 Senior 20 Freshman 21 Senior 19 Sophomore 21 Junior 21 Senior 21 Junior 20 Junior 23 Senior 20 Sophomore 21 Sophomore 30 25 25 25 25 20 32 18 21 28 27 27 25 22 26 A2A339779 17 21 19 25 19 21 19. 23 26 21 24 16 2222 21 25 24 67 M 20 Junior 68 M 22 Senior 69 M 22 Junior 70 F 21 Sophomore 71 M 18 Freshman 72 F 22 Junior 78 F 19 Freshman 74 M 21 Junior 75 F 18 Freshman 76 M 20 Sophomore 77 F 21 Junior 78 M 19 Freshman 79 F 21 Senior 80 F 19 Sophomore 81 19 Sophomore 82 F 20 Junior 83 M 19 Freshman 84 20 Junior 85 M 22 Senior 86 F 21 Senior 87 M 19 Freshman 88 F 18 Freshman 89 F 21 Sophomore 90 21 Senior 91 20 Sophomore 92 18 Freshman 93 20 Junior 94 F 19 Sophomore 95 F 20 Junior 20 Sophomore 19 Sophomore 23 Senior 21 Junior Coco 66 234 666 567 96 97 98 829 99 FL F LL LL FMMF M FMM 22 27 228 2288 22897282987222222222 23 18 18 30 24 24 30 20 23 24 23 26 26 26 26 25 24 23 24 25 100 M 101 F 102 M 103 F 104 M 105 F 106 F 107 F 108 F 109 F 110 F 111 F 112 F 113 F 114 F 115 M 116 M 117 F 118 F 119 F 120 F 121 F 122 M 123 M 124 M 125 F 126 M 127 M 128 M 129 M 130 F 131 M 132 M 19 Sophomore 19 Sophomore 22 Senior 22 Senior 22 Senior 21 Sophomore 19 Freshman 22 Senior 22 Senior 20 Sophomore 18 Freshman 21 Senior 22 Senior 18 Freshman 20 Sophomore 22 Junior 24 Senior 21 Junior 19 Sophomore 20 Junior 21 Junior 21 Junior 20 Sophomore 22 Senior 20 Sophomore 21 Senior 20 Sophomore 35 Senior 20 Sophomore 21 Senior 19 Freshman 22 Senior 21 Junior 827227228728828982 30 25 26 26 21 20 25 30 24 23 20 21 20 24 19 21 23 20 18 24 31 21 24 15 29 24 21 26 133 M 134 F 135 M 136 M 137 F 138 F 139 F 140 M 141 F 142 F 143 M 144 M. 145 M 146 F 147 M 148 F 149 F 150 F 151 F 152 F 153 M 154 M 155 F 156 M 157 F 158 F 159 M 160 F 161 F 162 M 163 M 164 F 165 F 166 F 21 Junior 19 Sophomore 22 Senior 20 Sophomore 22 Senior 22 Junior 19 20 Junior 23 Senior 19 Freshman 22 Senior 21 Sophomore 22 Senior 20 Sophomore 23 21 Senior 20 Junior 21 Junior 18 Sophomore 23 Senior 20 Sophomore 23 Senior 22 Junior 20 Sophomore 22 Senior 20 Junior 19 Sophomore 23 Senior 21 Junior 19 Sophomore 20 Junior 21 Junior 18 Freshman 20 Junior 20 Sophomore Freshman N222222222222222222 SNE 27 26 28 19 28 28 23 18 29 17 25 20 17 26 25 24 26 27 24 21 24 30 32 23 34 25 26 26 27 26 17 167 F 168 F 169 F 170 F 171 F 172 F 173 F 174 F 175 F 176 F 177 F 178 M 179 F 180 F 181 F 182 F 183 M 184 F 185 M 186 M 187 M 188 M 189 M 190 M 191 F 192 F 193 F 194 F 195 F 196 F 197 F 198 F 199 F 200 n 20 Junior 19 Sophomore 19 Sophomore 20 Sophomore 20 Sophomore 20 Sophomore 21 Junior 21 Senior 22 Senior 35 Junior 22 Senior 22 Junior 20 Junior 19 Freshman 20 Junior 22 Junior 21 Senior 22 Junior 20 Junior 20 Sophomore 22 Senior 24 Senior 22 Senior 19 Sophomore 21 Junior 19 Sophomore 22 Junior 32 Senior 21 Junior 18 Freshman 20 Sophomore 21 Junior 20 Sophomore 22 Senior 30 16 26 17 23 18 29 23 21 17 27 27 28 23 29 15 25 23 31 19 27 20 19 29 19 26 24 26 32 24 18 19 29 01