CASE NOTES:

This spreadsheet contains data for the number of patients obtaining an MRI $($Magnetic Resonance Imaging$)$ scan at a small local hospital. Currently the hospital has $3$ older scanning units. $($Magnetic resonance imaging $($MRI$)$ is a medical imaging technique that uses a magnetic field and computer$-$generated radio waves to create detailed images of the organs and tissues in your body.$)$

The MRI Director noticed a pattern of MRI requests based on time of year $\backslash$& weather patterns. Therefore, she combined the aggregate data into $4-$forecasting seasons: Fall $($Sept$,$ Oct, Nov$),$ Winter $($Dec$,$ Jan, Feb$),$ Spring $($March$,$ April, May$),\backslash$& Summer $($June$,$ July, Aug$).$

The hospital is experiencing a $\backslash (12\backslash \%\backslash )$ increase in MRI patients. The community is experiencing high population growth for the $\backslash (40-70\backslash )$ year old demographic. The Hospital Director expects MRI demand to continue a $\backslash (12\backslash \%\backslash )$ yearly increase, thus she wants to ensure the facilities can handle this growth.

Initially the Director would like the following analysis:

$-$Graph the data to confirm the seasonality pattern.

$-$From the historical data, calculate:

$-$Patient Count Seasonal Averages $($Round to nearest whole number$)$

$-2022-2024$ Patient Count Overall Average $($Round to nearest whole number$)$

$-$Seasonal Indices $($Percent $-$ Round to $2$ decimal places$)$

$-2025$ Projected Total Patient Count with a $12\backslash \%$ increase over the $2024$ Patient Count nearest whole number$)$

$-2025$ New Patient Count Overall Average $($Round to nearest whole number$)$

$-2025$ Breakdown of MRI Patient Counts by Season $($Round to nearest whole number$)$

NOTE: Round all patient data to nearest whole number. Instructor must be able to view FORMULAS used for cell calculations. Typed in final answers will not be accepted.