Veronica_Perez_Act_I_ A_Late_Arrival_Workbook

xlsx

School

Arizona State University *

*We aren’t endorsed by this school

Course

181

Subject

Statistics

Date

Feb 20, 2024

Type

xlsx

Pages

21

Uploaded by DrElement444

Report
Number of eggs laid 2324 2728 2648 2890 2648 2244 2648 2486 2324 2648 2567 2486 2486 2890 2405 2324 2324 2648 2001 2728 2648 2405 2567 2486 2809 2648 2567 2486 2405 2648 2324 The data in this sheet will be used for assignment questions 2-13. Use the Excel sheets (tabs) labeled " Question 2 " and " Q5-13 Number of Eggs Analysis " for all calculations, modeling, and graphing.
2648 2567 2728 2648 2405 2728
Number of eggs laid 2324 2728 2648 2890 2648 2244 2648 2486 2324 2648 2567 2486 2486 2890 2405 2324 2324 2648 2001 2728 2648 2405 2567 2486 2809 2648 2567 2486 2405 2648 2324 Plot the frequency distribution (also known as a histogram) of the number of eggs laid in past breeding seasons. Refer to the lab packet for formatting instructions. This chart isn't available in your version of Excel. Editing this shape or saving this workbook into a different file format will permanently break the chart.
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
2648 2567 2728 2648 2405 2728
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
Number of eggs laid 2001 2244 2324 2324 2324 2324 2324 2405 2405 2405 2405 Column1 Column2 2486 Mean 2545 2486 Median 2567 2486 mode 2648 2486 Min 2001 2486 Max 2890 2567 STDEV 188 2567 2567 2567 Column1 Column2 2648 Eggs under 2217 2648 Probability 4% 2648 2648 2648 2648 2648 2648 2648 2648 1/37= 0.027 * 100= 2.7 % 2728 Perform the statistical analyses to report including the mean, median, mode, min, and max values. These are for questions 5-13. See the lab packet for specific rounding instructions for each question. This chart isn't Editing this sh
2728 2728 Column1 Column2 Column3 Column4 2728 2809 1/37= 0.027 * 100 = 2.7% 2890 2890 Probability of observing fewer than 2217 eggs
t available in your version of Excel. hape or saving this workbook into a different file format will permanently break the chart.
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
Column5 Column6 Column7 Column8 4% s in a past breeding season = 
Mean yolk mass (g) 153 155 160 163 164 164 169 170 171 173 174 176 179 179 180 182 183 184 185 186 187 188 190 193 193 194 195 197 198 201 202 The data in this sheet will be used for assignment questions 15-18. Use the Excel sheets (tabs) labeled " Question 15 " and " Q16-18 Egg Yolk Mass Analysis " for all calculations, modeling, and graphing. 2 3 4 5 6 7 8 9 Frequency
202 206 207 211 211 233 <160 0 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
Frequency of Mean Yolk Mass
160-170 170-180 180-190 190-200 200-210 210-220 >220 Ranges of Yolk Mass
Mean yolk mass (g) 153 155 160 163 164 164 169 170 171 173 174 Column1 176 bins 179 Ranges of Yolk Frequency 179 150 <160 2 180 160 160-170 5 182 170 170-180 7 183 180 180-190 8 184 190 190-200 6 185 200 200-210 5 186 210 210-220 2 187 220 >220 1 188 190 193 193 194 195 197 198 201 202 Plot the frequency distribution (also known as a histogram) of the mean yolk mass of eggs laid in past breeding seasons. Refer to the lab packet for formatting instructions. 0 1 2 3 4 5 6 7 8 9 Frequency
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
202 206 207 211 211 233 <160 160 0
Frequency of Mean Yolk Mass
0-170 170-180 180-190 190-200 200-210 210-220 >220 Ranges of Yolk Mass
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
Mean yolk mass (g) 153 155 160 163 164 164 169 170 171 173 174 176 179 179 180 182 183 184 185 186 187 Column1 Column2 188 min 153 190 median 185.351351351351 193 mean 185 193 max 233 194 Mode 164 195 SD 17.5755768298199 197 198 Column2 Column1 201 Probability 4% 202 Yolk mass (g) 154 Perform the statistical analyses to report including the mean, stddev. median, min, and max values. These are for questions 16-18 and as needed through the end of this assignment. For question 18, express your answer as a decimal between 0 and 1, rounding the value to the nearest hundredth of a decimal place. For example, if you calculate a probability of 0.448, report a value of 0.45. Do not round intermediate calculations.
202 Decimal form 0.03888 206 Column1 Column2 207 Appendix 3 211 Mean 396 211 SD 58 233 Observed value 381 Probability 60%
<160 160-170 170-180 180-190 190-200 200-210 210-220 >220 0 1 2 3 4 5 6 7 8 9 Frequency of Mean Yolk Mass Ranges of Yolk Mass Frequency
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