Project 1- COVID-Cases Analysis ( Click On Backup Covid Data)-2

xlsx

School

Northern Virginia Community College *

*We aren’t endorsed by this school

Course

154

Subject

Statistics

Date

Feb 20, 2024

Type

xlsx

Pages

27

Uploaded by BaronArmadillo3003

Report
Project 1: COVID-19 Data Analysis last updated 1/11/2023 I certify that this is my own work, done by myself. EM Name: Erick Membreno MTH154- <Section> Fairfax County 2020 Population 1,147,532 Pop in 100K units 11.4753 Area in square miles 391.0 Pop density per sq mi 2,935 Per Capita (per person) Income 56,231 Pop Percent w/ college degree 61.6% Pop Percent NO health insurance 8.8% Pop percent foreign born 31.0% 3/21 22 Fairfax Fairfax 0 Fairfax Fairfax 3/28 156 134 11.68 2 2 0.17 4/4 387 231 20.13 6 4 0.35 4/11 947 560 48.80 20 14 1.22 4/18 1,636 689 60.04 43 23 2.00 4/25 2,797 1,161 101.17 94 51 4.44 5/2 4,101 1,304 113.64 157 63 5.49 5/9 5,686 1,585 138.12 237 80 6.97 5/16 7,475 1,789 155.90 285 48 4.18 5/23 9,044 1,569 136.73 334 49 4.27 5/30 11,026 1,982 172.72 397 63 5.49 6/6 12,180 1,154 100.56 426 29 2.52 6/13 13,062 882 76.86 436 10 0.87 6/20 13,468 406 35.38 448 12 1.05 6/27 13,854 386 33.64 482 34 2.96 7/4 14,197 343 29.89 510 28 2.44 7/11 14,528 331 28.84 513 3 0.26 7/18 14,925 397 34.60 523 10 0.87 7/25 15,394 469 40.87 528 5 0.44 8/1 15,828 434 37.82 535 7 0.61 2020 Week End Date Cumulative Cases Weekly Cases Weekly Normalized Cases per 100K pop Cumulative Deaths Weekly Deaths Weekly Normalized Deaths per 100K pop
8/8 16,447 619 53.94 543 8 0.70 8/15 17,042 595 51.85 546 3 0.26 8/22 17,701 659 57.43 553 7 0.61 8/29 18,378 677 59.00 569 15 1.31 9/5 19,068 690 60.13 576 7 0.61 9/12 19,688 620 54.03 582 6 0.52 9/19 20,357 669 58.30 592 10 0.87 9/26 20,893 563 49.06 601 9 0.78 10/3 21,385 492 42.87 605 4 0.35 10/10 22,078 693 60.39 614 9 0.78 10/17 22,756 678 59.08 616 2 0.17 10/24 23,463 707 61.61 621 5 0.44 Minimum Weekly 11.7 0.17 Average Weekly 86.10 3.00 Maximum Weekly 172.7 6.97 Minimum Weekly 28.8 0.17 Average Weekly 49.4 0.71 Maximum Weekly 61.6 2.44 11.68 37.82 9.67 52.72 9.78 82.28 20.13 53.94 23.21 58.04 24.45 159.89 48.8 51.85 35.31 55.13 55.07 114.39 60.04 57.43 28.29 48.85 78.45 124.59 101.17 59 36.51 58.04 123.1 99.08 113.64 60.13 76.66 58.52 181.15 111.84 138.12 54.03 59.49 58.76 167.54 105.67 155.9 58.3 73.27 54.17 275.97 97.16 136.73 49.06 96.97 38.45 236 111.41 172.72 42.87 168.79 39.17 282.14 96.74 100.56 60.39 99.14 54.89 197.52 87.81 76.86 59.08 92.37 78.35 105.03 62.51 35.38 61.61 53.68 54.41 82.28 99.29 33.64 83.91 85.68 95.25 29.89 68.92 81.64 102.91 28.84 47.88 73.35 34.6 53.92 Statistics for Weeks 13-26 Statistics for Weeks 27 - 43 ➘➘ Insert weekly CASES per 100,000 chart below ➘➘
40.87 48.36 Question 1: Of the 3 counties, which has had the lowest Normalized Weekly Case rates of infections over most of the period? You can get an "eyeball" answer from the graph, or better, by comparing the Average Weekly rates you calculated in the Stats blocks above. Fairfax County Question 3: What events or changes in policy or behaviors might explain the differences in infection rates seen in Weeks 13-26 (March-June) compared to Weeks 27-43 (July-October)? THESE ARE WEEKS IN 2020, NOT 2022. Maybe peoples behavior started to change once they realeased it was not safe to be around others. In policy, i remember the government did not allow public places or restaurants to open until further notice. Maybe all these factors could explain the differences. BONUS POINTS - Reflections: Share your reaction to what you learned in this Project. I learned to use cell formulas which helped me understand more about excel. I leaned how to insert a graph chart into excel. I learned that if I ever wanted to get some data from any resource, I can use these same tecniques to get such data. Thanks to my teacher that teached me more about excel. Without the help, I would not be able to learn about excel, formulas, graphs etc. All questions refer to year
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
ALL DATA ARE FROM YEAR 2020 THE FIRST YEAR O Loudoun County 2020 Population 413,538 Pop in 100K units 4.1354 Area in square miles 516.0 Pop density per sq mi 801.4 Per Capita (per person) Income 55,744 Per Ca Pop Percent w/ college degree 61.3% Pop P Pop Percent NO health insurance 6.9% Pop Per Pop percent foreign born 25.0% 14 Loudoun Loudoun 0 Loudoun Loudoun 14 54 40 9.67 1 1 0.24 60 150 96 23.21 4 3 0.73 175 296 146 35.31 5 1 0.24 434 413 117 28.29 7 2 0.48 803 564 151 36.51 11 3 0.73 1,382 881 317 76.66 16 5 1.21 2,234 1,127 246 59.49 30 14 3.39 3,022 1,430 303 73.27 48 18 4.35 4,320 1,831 401 96.97 52 4 0.97 5,430 2,529 698 168.79 63 11 2.66 6,757 2,939 410 99.14 67 4 0.97 7,686 3,321 382 92.37 71 4 0.97 8,180 3,543 222 53.68 82 11 2.66 8,567 3,890 347 83.91 86 4 0.97 8,970 4,175 285 68.92 91 5 1.21 9,354 4,373 198 47.88 99 8 1.93 9,708 4,596 223 53.92 103 4 0.97 10,095 4,796 200 48.36 106 3 0.73 10,460 5,014 218 52.72 112 6 1.45 10,998 Cumulative Cases Weekly Cases Weekly Normalized Cases per 100K pop Cumulative Deaths Weekly Deaths Weekly Normalized Deaths per 100K pop Cumulative Cases
5,254 240 58.04 115 3 0.73 11,584 5,482 228 55.13 115 0 0.00 12,050 5,684 202 48.85 115 0 0.00 12,576 5,924 240 58.04 118 3 0.73 13,073 6,166 242 58.52 118 0 0.00 13,530 6,409 243 58.76 118 0 0.00 14,054 6,633 224 54.17 123 5 1.21 14,509 6,792 159 38.45 124 1 0.24 14,922 6,954 162 39.17 126 2 0.48 15,216 7,181 227 54.89 128 2 0.48 15,683 7,505 324 78.35 129 1 0.24 16,131 7,730 225 54.41 130 1 0.24 16,615 Minimum Weekly 9.7 0.24 Minim Average Weekly 66.9 1.47 Ave Maximum Weekly 168.8 4.35 Maxim Minimum Weekly 38.4 0.00 Minim Average Weekly 54.6 0.63 Ave Maximum Weekly 78.3 1.93 Maxim 0.17 0.87 0.24 0 0.21 0.43 0.35 0.44 0.73 0.73 0.21 1.06 1.22 0.61 0.24 0 0.85 0.43 2 0.7 0.48 0 1.91 1.06 4.44 0.26 0.73 1.21 4.89 0.85 5.49 0.61 1.21 0.24 2.34 1.7 6.97 1.31 3.39 0.48 4.04 1.06 4.18 0.61 4.53 0.48 5.53 1.28 4.27 0.52 0.97 0.24 3.83 0.64 5.49 0.87 0.97 0.24 5.32 1.28 2.52 0.78 2.66 1.7 1.49 0.87 0.35 0.97 2.13 1.05 0.78 0.73 2.98 2.96 0.17 1.45 1.7 2.44 0.44 0.73 2.34 0.26 0 2.13 1.49 ➘➘ Insert weekly DEATHS per 100,000 chart below ➘➘
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
1.28 Question 2: Considering the population demographic information about the 3 counties given in Rows 8 - 15 above, which factors might tend to explain your answer to Question 1? What differences between counties most likely affect the spread of diseases? I think Fairfax county did not go out a lot, most people took care of them selves taken the situation more serious. I also believe thanks to the government who prevented public stores in order to stop the spread of diseases. I think the differences between counties was that people tended to socialize more by going out to places where a lot of people were at. For example malls, restaurants, and parks etc. They were more social. Question 4: Looking at the Normalized Weekly Deaths columns after the weeks 13-26, are you surprised at the low values for Deaths per 100,000 in each of the Counties? How do these data compare with the impression you got from listening to news commentators about the pandemic impact? I am surprised! I remember the news said the deaths supposedly went up but here in the chart for Fairfax, Londoun, and Prince william went down. r 2020, NOT 2022!
OF WIDESPREAD COVID-19 Prince William County 2020 Population 470,335 Pop in 100K units 4.7034 Area in square miles 336.0 Pop density per sq mi 1,399.8 apita (per person) Income 40,932 Percent w/ college degree 41.1% rcent NO health insurance 11.7% Pop percent foreign born 26.0% Pr William Pr William 0 Pr William Pr William 46 9.78 1 1 0.21 115 24.45 2 1 0.21 259 55.07 6 4 0.85 369 78.45 15 9 1.91 579 123.10 21 6 4.89 852 181.15 32 11 2.34 788 167.54 51 19 4.04 1,298 275.97 77 26 5.53 1,110 236.00 95 18 3.83 1,327 282.14 120 25 5.32 929 197.52 128 8 1.70 494 105.03 138 10 2.13 387 82.28 152 14 2.98 403 85.68 160 8 1.70 384 81.64 171 11 2.34 345 73.35 181 10 2.13 387 82.28 188 7 1.49 752 159.89 194 6 1.28 538 114.39 199 5 1.06 Weekly Cases Weekly Normalized Cases per 100K pop Cumulative Deaths Weekly Deaths Weekly Normalized Deaths per 100K pop
586 124.59 205 6 1.28 466 99.08 207 2 0.43 526 111.84 212 5 1.06 497 105.67 214 2 0.43 457 97.16 219 5 1.06 524 111.41 223 4 0.85 455 96.74 231 8 1.70 413 87.81 236 5 1.06 294 62.51 242 6 1.28 467 99.29 245 3 0.64 448 95.25 251 6 1.28 484 102.91 258 7 1.49 mum Weekly 9.8 0.21 erage Weekly 136.0 2.69 mum Weekly 282.1 5.53 mum Weekly 62.5 0.43 erage Weekly 100.3 1.23 mum Weekly 159.9 2.34
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
Project 1: COVID-19 Data Analysis Name: Erick Membreno MTH154- Note: all data are from 2020 Fairfax County 2020 Population 1,147,532 Pop in 100K units 11.4753 Area in square miles 391.0 Pop density per sq mi 2,935 Per Capita (per person) Income 56,231 Pop Percent w/ college degree 61.6% Pop Percent NO health insurance 8.8% Pop percent foreign born 31.0% 12 3/21 22 Fairfax Fairfax 0 Fairfax Fairfax 13 3/28 156 2 14 4/4 387 6 15 4/11 947 20 16 4/18 1,636 43 17 4/25 2,797 94 18 5/2 4,101 157 19 5/9 5,686 237 20 5/16 7,475 285 21 5/23 9,044 334 22 5/30 11,026 397 23 6/6 12,180 426 24 6/13 13,062 436 25 6/20 13,468 448 26 6/27 13,854 482 27 7/4 14,197 510 28 7/11 14,528 513 29 7/18 14,925 523 30 7/25 15,394 528 31 8/1 15,828 535 32 8/8 16,447 543 2020 Week Num 2020 Week End Date Cumulative Cases Weekly Cases Weekly Normalized Cases per 100K pop Cumulative Deaths Weekly Deaths Weekly Normalized Deaths per 100K pop
33 8/15 17,042 546 34 8/22 17,701 553 35 8/29 18,378 569 36 9/5 19,068 576 37 9/12 19,688 582 38 9/19 20,357 592 39 9/26 20,893 601 40 10/3 21,385 605 41 10/10 22,078 614 42 10/17 22,756 616 43 10/24 23,463 621 Minimum Weekly Average Weekly Maximum Weekly Minimum Weekly Average Weekly Maximum Weekly Statistics for Weeks 13-26 Statistics for Weeks 27 - 43 ➘➘ Insert weekly CASES per 100,000 chart below ➘➘ Question 1: Of the 3 counties, which has had the lowest Normalized Weekly Case rates of infections over most of the period? You can get an "eyeball" answer from the graph, or
BONUS POINTS - Reflections: Share your reaction to what you learned in this Project. infections over most of the period? You can get an "eyeball" answer from the graph, or better, by comparing the Average Weekly rates you calculated in the Stats blocks above. Question 3: What events or changes in policy might explain the differences in infection rates seen in Weeks 13-26 (March-June) compared to Weeks 27-43 (July-October)?
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
Loudoun County 2020 Population 413,538 Pop in 100K units 4.1354 Area in square miles 516.0 Pop density per sq mi 801.4 Per Capita (per person) Income 55,744 Per Ca Pop Percent w/ college degree 61.3% Pop P Pop Percent NO health insurance 6.9% Pop Per Pop percent foreign born 25.0% 14 Loudoun Loudoun 0 Loudoun Loudoun 14 54 1 60 150 4 175 296 5 434 413 7 803 564 11 1,382 881 16 2,234 1,127 30 3,022 1,430 48 4,320 1,831 52 5,430 2,529 63 6,757 2,939 67 7,686 3,321 71 8,180 3,543 82 8,567 3,890 86 8,970 4,175 91 9,354 4,373 99 9,708 4,596 103 10,095 4,796 106 10,460 5,014 112 10,998 5,254 115 11,584 Cumulative Cases Weekly Cases Weekly Normalized Cases per 100K pop Cumulative Deaths Weekly Deaths Weekly Normalized Deaths per 100K pop Cumulative Cases
5,482 115 12,050 5,684 115 12,576 5,924 118 13,073 6,166 118 13,530 6,409 118 14,054 6,633 123 14,509 6,792 124 14,922 6,954 126 15,216 7,181 128 15,683 7,505 129 16,131 7,730 130 16,615 Minimum Weekly Minim Average Weekly Ave Maximum Weekly Maxim Minimum Weekly Minim Average Weekly Ave Maximum Weekly Maxim ➘➘ Insert weekly DEATHS per 100,000 chart below ➘➘ Question 2: Considering the population statistics information about the 3 counties given in Rows 8 - 15 above, which factors might tend to explain your answer to Question 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
in Rows 8 - 15 above, which factors might tend to explain your answer to Question 1? Question 4: Looking at the Normalized Weekly Deaths columns after the weeks 13-26, are you surprised at the low values for Deaths per 100,000 in each of the Counties? How do these data compare with the impression you get from listening to news commentators about the pandemic impact?
Prince William County 2020 Population 470,335 Pop in 100K units 4.7034 Area in square miles 336.0 Pop density per sq mi 1,399.8 apita (per person) Income 40,932 Percent w/ college degree 41.1% rcent NO health insurance 11.7% Pop percent foreign born 26.0% Pr William Pr William 0 Pr William Pr William 1 2 6 15 21 32 51 77 95 120 128 138 152 160 171 181 188 194 199 205 Weekly Cases Weekly Normalized Cases per 100K pop Cumulative Deaths Weekly Deaths Weekly Normalized Deaths per 100K pop
207 212 214 219 223 231 236 242 245 251 258 mum Weekly erage Weekly mum Weekly mum Weekly erage Weekly mum Weekly
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
Fairfax County 2020 Population 1,147,532 Pop in 100K units 14.4753 Area in square miles 391.0 Pop density per sq mi 2,935 er Capita (per person) Income 56,231 Pop Percent w/ college degree 61.6% Percent NO health insurance 8.8% Pop percent foreign born 31.0% 3/21 22 Fairfax Fairfax 0 Fairfax Fairfax 3/28 156 134 11.68 2 2 0.14 4/4 387 231 20.13 6 4 0.28 4/11 947 560 48.80 20 14 0.97 4/18 1,636 689 60.04 43 23 1.59 4/25 2,797 1,161 101.17 94 51 4.44 5/2 4,101 1,304 113.64 157 63 5.49 5/9 5,686 1,585 138.12 237 80 6.97 5/16 7,475 1,789 155.90 285 48 4.18 5/23 9,044 1,569 136.73 334 49 4.27 5/30 11,026 1,982 172.72 397 63 5.49 End Date e Cases Weekly Cases Cases per 100K pop Cumulative Deaths Weekly Deaths per 100K pop
6/6 12,180 1,154 100.56 426 29 2.52 6/13 13,062 882 76.86 436 10 0.87 6/20 13,468 406 35.38 448 12 1.05 6/27 13,854 386 33.64 482 34 2.96 7/4 14,197 343 29.89 510 28 2.44 7/11 14,528 331 28.84 513 3 0.26 7/18 14,925 397 34.60 523 10 0.87 7/25 15,394 469 40.87 528 5 0.44 8/1 15,828 434 37.82 535 7 0.61 8/8 16,447 619 53.94 543 8 0.70 8/15 17,042 595 51.85 546 3 0.26 8/22 17,701 659 57.43 553 7 0.61 8/29 18,378 677 59.00 569 15 1.31 9/5 19,068 690 60.13 576 7 0.61 9/12 19,688 620 54.03 582 6 0.52 9/19 20,357 669 58.30 592 10 0.87 9/26 20,893 563 49.06 601 9 0.78 10/3 21,385 492 42.87 605 4 0.35 10/10 22,078 693 60.39 614 9 0.78 10/17 22,756 678 59.08 616 2 0.17 10/24 23,463 707 61.61 621 5 0.44 Minimum Weekly 11.7 0.14 Average Weekly 86.10 2.94 Maximum Weekly 172.7 6.97 Minimum Weekly 28.8 0.17 Average Weekly 49.4 0.71 Maximum Weekly 61.6 2.44 11.68 37.82 9.67 52.72 9.78 82.28 20.13 53.94 23.21 58.04 24.45 159.89 48.8 51.85 35.31 55.13 55.07 114.39 60.04 57.43 28.29 48.85 78.45 124.59 101.17 59 36.51 58.04 123.1 99.08 113.64 60.13 76.66 58.52 181.15 111.84 138.12 54.03 59.49 58.76 167.54 105.67 155.9 58.3 73.27 54.17 275.97 97.16 Statistics for Weeks 13-26 Statistics for Weeks 27 - 43 ➘➘ Insert weekly CASES per 100,000 chart below ➘➘ 200 250 300 5 6 7 8
136.73 49.06 96.97 38.45 236 111.41 172.72 42.87 168.79 39.17 282.14 96.74 100.56 60.39 99.14 54.89 197.52 87.81 76.86 59.08 92.37 78.35 105.03 62.51 35.38 61.61 53.68 54.41 82.28 99.29 33.64 83.91 85.68 95.25 29.89 68.92 81.64 102.91 28.84 47.88 73.35 34.6 53.92 40.87 48.36 Question 1: Of the 3 counties, which has had the lowest Normalized Weekly Case rates of infections over most of the period? You can get an "eyeball" answer from the graph, or better, by comparing the Average Weekly rates you calculated in the Stats blocks above. Fairfax County Question 3: What events or changes in policy or behaviors might explain the differences in infection rates seen in Weeks 13-26 (March-June) compared to Weeks 27-43 (July-October)? THESE ARE WEEKS IN 2020, NOT 2022. Maybe peoples behavior started to change once they realeased it was not safe to be around others. In policy, i remember the government did not allow public places or restaurants to open until further notice. Maybe all these factors could explain the differences. 0 50 100 150 11.68 11.68 9.67 0 1 2 3 4 All questions refer to year
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
BONUS POINTS - Reflections: Share your reaction to what you learned in this Project. I learned to use cell formulas which helped me understand more about excel. I leaned how to insert a graph chart into excel. I learned that if I ever wanted to get some data from any resource, I can use these same tecniques to get such data.
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
Loudoun County Prince Wil 2020 Population 413,538 2020 Population Pop in 100K units 4.1354 Pop in 100K units Area in square miles 516.0 Area in square miles Pop density per sq mi 801.4 Pop density per sq mi er Capita (per person) Income 55,744 er Capita (per person) Income Pop Percent w/ college degree 61.3% op Percent w/ college degree Percent NO health insurance 6.9% Percent NO health insurance Pop percent foreign born 25.0% Pop percent foreign born 14 Loudoun Loudoun 0 Loudoun Loudoun 14 54 40 9.67 1 1 0.24 60 46 9.78 150 96 23.21 4 3 0.73 175 115 24.45 296 146 35.30 5 1 0.24 434 259 55.07 413 117 28.29 7 2 0.48 803 369 78.45 564 151 36.51 11 3 0.73 1,382 579 123.10 881 317 76.66 16 5 1.21 2,234 852 181.15 1,127 246 59.49 30 14 3.39 3,022 788 167.54 1,430 303 73.27 48 18 4.35 4,320 1,298 275.97 1,831 401 96.97 52 4 0.97 5,430 1,110 236.00 2,529 698 168.79 63 11 2.66 6,757 1,327 282.14 e Cases Weekly Cases Cases per 100K pop Cumulative Deaths Weekly Deaths per 100K pop e Cases Weekly Cases Cases per 100K pop Pr William Pr William
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
2,939 410 99.14 67 4 0.97 7,686 929 197.52 3,321 382 92.37 71 4 0.97 8,180 494 105.03 3,543 222 53.68 82 11 2.66 8,567 387 82.28 3,890 347 83.91 86 4 0.97 8,970 403 85.68 4,175 285 68.92 91 5 1.21 9,354 384 81.64 4,373 198 47.88 99 8 1.93 9,708 345 73.35 4,596 223 53.92 103 4 0.97 10,095 387 82.28 4,796 200 48.36 106 3 0.73 10,460 752 159.88 5,014 218 52.72 112 6 1.45 10,998 538 114.39 5,254 240 58.04 115 3 0.73 11,584 586 124.59 5,482 228 55.13 115 0 0.00 12,050 466 99.08 5,684 202 48.85 115 0 0.00 12,576 526 111.83 5,924 240 58.04 118 3 0.73 13,073 497 105.67 6,166 242 58.52 118 0 0.00 13,530 457 97.16 6,409 243 58.76 118 0 0.00 14,054 524 111.41 6,633 224 54.17 123 5 1.21 14,509 455 96.74 6,792 159 38.45 124 1 0.24 14,922 413 87.81 6,954 162 39.17 126 2 0.48 15,216 294 62.51 7,181 227 54.89 128 2 0.48 15,683 467 99.29 7,505 324 78.35 129 1 0.24 16,131 448 95.25 7,730 225 54.41 130 1 0.24 16,615 484 102.90 Minimum Weekly 9.7 0.24 Minimum Weekly 9.8 Average Weekly 66.9 1.47 Average Weekly 136.0 Maximum Weekly 168.8 4.35 Maximum Weekly 282.1 Minimum Weekly 38.4 0.00 Minimum Weekly 62.5 Average Weekly 54.6 0.63 Average Weekly 100.3 Maximum Weekly 78.3 1.93 Maximum Weekly 159.9 0.17 0.87 0.24 0 0.21 0.43 0.35 0.44 0.73 0.73 0.21 1.06 1.22 0.61 0.24 0 0.85 0.43 2 0.7 0.48 0 1.91 1.06 4.44 0.26 0.73 1.21 4.89 0.85 5.49 0.61 1.21 0.24 2.34 1.7 6.97 1.31 3.39 0.48 4.04 1.06 4.18 0.61 4.53 0.48 5.53 1.28 ➘➘ Insert weekly DEATHS per 100,000 chart below ➘➘
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
4.27 0.52 0.97 0.24 3.83 0.64 5.49 0.87 0.97 0.24 5.32 1.28 2.52 0.78 2.66 1.7 1.49 0.87 0.35 0.97 2.13 1.05 0.78 0.73 2.98 2.96 0.17 1.45 1.7 2.44 0.44 0.73 2.34 0.26 0 2.13 1.49 1.28 Question 2: Considering the population demographic information about the 3 counties given in Rows 8 - 15 above, which factors might tend to explain your answer to Question 1? What differences between counties most likely affect the spread of diseases? I think Fairfax county did not go out a lot, most people took care of them selves taken the situation more serious. I also believe thanks to the government who prevented public stores in order to stop the spread of diseases. I think the differences between counties was that people tended to socialize more by going out to places where a lot of people were at. For example malls, restaurants, and parks etc. They were more social. Question 4: Looking at the Normalized Weekly Deaths columns after the weeks 13-26, are you surprised at the low values for Deaths per 100,000 in each of the Counties? How do these data compare with the impression you got from listening to news commentators about the pandemic impact? I am surprised! I remember the news said the deaths supposedly went up but here in the chart for Fairfax, Londoun, and Prince william went down. 0.17 0.17 0.24 2020, NOT 2022!
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
lliam County 470,335 4.7034 336.0 1,399.8 40,932 47033500.0% 11.7% 26.0% 0 1 1 0.21 2 1 0.21 6 4 0.85 15 9 1.91 21 6 4.89 32 11 2.34 51 19 4.04 77 26 5.53 95 18 3.83 120 25 5.32 Cumulative Deaths Weekly Deaths per 100K pop Pr William Pr William
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
128 8 1.70 138 10 2.13 152 14 2.98 160 8 1.70 171 11 2.34 181 10 2.13 188 7 1.49 194 6 1.28 199 5 1.06 205 6 1.28 207 2 0.43 212 5 1.06 214 2 0.43 219 5 1.06 223 4 0.85 231 8 1.70 236 5 1.06 242 6 1.28 245 3 0.64 251 6 1.28 258 7 1.49 0.21 2.69 5.53 0.43 1.23 2.34
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

Related Documents

S-Practice -Lab 1.docx
Homework 2 Solution.pdf
F23_hw2.docx
Homework 2.docx
Lab 6.docx
Lab 4.docx
ANLY 502-90-Math-Assignment 2.docx
Midtern Exam.docx
BarnumVictoria Lab 2 - MAT121.docx
BarnumVictoriaLabManual Section 2.1.docx
Lab 2.docx
Screenshot 2024-02-17 at 12.20.01 p.m..png
Recommended textbooks for you
Text book image
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:9781133382119
Author:Swokowski
Publisher:Cengage
Text book image
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Text book image
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Text book image
Linear Algebra: A Modern Introduction
Algebra
ISBN:9781285463247
Author:David Poole
Publisher:Cengage Learning
Text book image
Mathematics For Machine Technology
Advanced Math
ISBN:9781337798310
Author:Peterson, John.
Publisher:Cengage Learning,
Text book image
College Algebra (MindTap Course List)
Algebra
ISBN:9781305652231
Author:R. David Gustafson, Jeff Hughes
Publisher:Cengage Learning
SEE MORE TEXTBOOKS
Recommended textbooks for you
Text book image
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:9781133382119
Author:Swokowski
Publisher:Cengage
Text book image
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Text book image
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Text book image
Linear Algebra: A Modern Introduction
Algebra
ISBN:9781285463247
Author:David Poole
Publisher:Cengage Learning
Text book image
Mathematics For Machine Technology
Advanced Math
ISBN:9781337798310
Author:Peterson, John.
Publisher:Cengage Learning,
Text book image
College Algebra (MindTap Course List)
Algebra
ISBN:9781305652231
Author:R. David Gustafson, Jeff Hughes
Publisher:Cengage Learning
SEE MORE TEXTBOOKS