Data analysis_Student_Final_Version

xlsx

School

Arizona State University *

*We aren’t endorsed by this school

Course

181

Subject

Statistics

Date

Feb 20, 2024

Type

xlsx

Pages

Uploaded by CorporalCaterpillarMaster926

IData analysis Lab Steps 1 Complete Table 1 2 Plot the frequency distribution of two age groups 3 Calculate Median, Min, Max, and Mode 4 Determine relative frequency of each range within each age group 5 Deternmine Probability that an individual has high cholesterol in each age group Blank cells = Enter data or formula 1. Fill out Table 1 2. Plot the frequency distribution of the two age groups 3. Calculate the Median, Min, Max, and Mode Blue Cells = Will autofill based on data you enter in previous Table (See Excel Tutorial "8. Frequency" in Canvas) - Define Bins - Use the FREQUENCY function to determine the frequency of individuals that fall within each bin. (See Excel Tutorial "8. Frequency" and "9. Saving Plots as Images"in Canvas) -Highlight the values in one of your frequency columns. -At the top of your menu bar, select insert and then click on the arrow next to the following icon - Select the first of the 2-D bar graphs -Select the x-axis values, then left click and choose Seleect data . -There are two methods to giving each bar a label, if your window looks different that the excel tutorial, press the edit button, then highlight the cells of your numerical ranges and select enter -Click on your graph, and in the top left corner select Add Chart Element under axis titles, add a primary verticle and primary horizontal title. -Please follow the formatting instructions found in your Mission Memo.

4. Determine relative frequency of each range within each age group 5. Determine Probability that an individual has high cholesterol in each age group (See Excel Tutorial "6. Functions: Describing Data" in Canvas) -Please see your Mission Memo for the syntax needed to find your median, min, max and mode. (See Excel Tutorial "8. Frequency" in Canvas) -First Determine the total number of data in your sample. -From there you will want to divide your frequency by the total number of people in the sample set. (See Excel Tutorial "7. Functions: The Count Family and Abs Cell References" in Canvas) - Determine the frequency of individuals with high colesterol (> 240 mg dL -1 ) in each age group - Determine the RELATIVE frequency of individuals with high colesterol in each age group

122 137 122 139 126 142 129 151 132 152 137 155 137 161 139 162 143 163 145 166 149 168 149 171 150 173 Table 1. Frequency 150 173 Bins 20-44 45-64 150 175 120-140 140 8 2 154 177 140-160 160 14 4 154 184 160-180 180 17 10 155 185 180-200 200 18 22 155 186 200-220 220 23 22 156 187 220-240 240 9 13 158 187 240-260 260 6 14 160 188 260-280 280 2 8 161 189 280-300 300 3 2 162 189 300-320 320 0 1 163 189 320-340 340 0 2 168 190 0 0 169 192 170 194 Table 2. Frequency 170 194 Bins 20-44 45-64 172 195 120-140 140 8 2 174 197 140-160 160 14 4 175 198 160-180 180 17 10 175 199 180-200 200 18 22 177 200 200-220 220 23 22 177 200 220-240 240 9 13 178 200 240-260 260 6 14 178 200 260-280 280 2 8 179 200 280-300 300 3 2 180 201 300-320 320 0 1 181 202 320-340 340 0 2 183 202 184 203 185 204 Table 3. Data Set 185 205 Cholesterol at age 20-44 Years Cholesterol at age 45-64 Years Cholesterol (mg dL -1 Cholesterol (mg dL -1

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

20-44 45-64 185 206 Median 8 8 187 207 Min 0 1 187 207 Max 23 22 188 208 Mode 0 2 189 210 190 211 191 214 Table 4. Frequency RELATIVE Freq 194 215 20-44 45-64 20-44 45-64 195 215 120-140 8 2 0.08 0.02 198 215 140-160 14 4 0.14 0.04 198 216 160-180 17 10 0.17 0.1 199 216 180-200 18 22 0.18 0.22 200 217 200-220 23 22 0.23 0.22 201 218 220-240 9 13 0.09 0.13 202 218 240-260 6 14 0.06 0.14 202 220 260-280 2 8 0.02 0.08 203 221 280-300 3 2 0.03 0.02 203 221 300-320 0 1 0 0.01 205 222 320-340 0 2 0 0.02 206 223 207 225 209 227 Table 5. 20-44 45-64 209 229 Freq_High_Chol 11 27 210 229 RFreq_High_Chol 0.11 0.27 211 229 Prob_High_Chol 11% 27% 211 232 211 232 212 236 213 240 214 241 214 241 219 243 219 243 220 246 220 246 220 247 226 251 226 251 227 254 228 255 228 256 233 259 236 259 238 264 239 264 241 266 Cholesterol (mg dL -1

244 268 252 269 254 274 254 279 255 280 265 288 276 296 285 308 288 322 290 331

120 - 140 140 - 160 160 - 180 180 - 200 200 - 220 220 - 240 240 - 260 260 - 280 280 - 300 300 - 320 320 - 340 0 5 10 15 20 25 TABLE 2 (20-44) Cholesterol in People at Ages 20-44 Years Frequency 5 10 15 20 25 Table 2 (45-64) uency

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

120 - 140 140 - 160 160 - 180 180 - 200 200 - 220 220 - 240 240 - 260 260 - 280 280 - 300 300 - 320 320 - 340 0 5 Chelesterol in People at Ages 45-64 Frequ