CASE NOTES:

This spreadsheet contains data for the number of patients obtaining an MRI (Magnetic Resonance Imaging) scan at a small local hopsital. Currently the hospital has 3 older scanning units. (Magnetic resonance imaging (MRI) isa 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 the year & weather pattersn. Therefore, she combined the aggregate data into four seasons: Fall (Sept, Oct, Nov), Winter (Dec, Jan, Feb), Spring (March, April, May), & Summer (June, July, Aug).

The hospital is experiencing a 12% increase in MRI patients from 2021-2022. Since COVID, the community is experiencing high population growth for the 40-70 year old demographic. The Hospital Director expects MRI demand to continue a 12% 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:

Seasonal Averages

2020-2022 Overall Average

Seasonal Indices (Percent -Round to 2 decimal places)

2023 Projected Sales with 12% increase

2023 New Overall Average

2023 Breakdown of MRI Patients by Season

NOTE: Round all patient data to nearest whole number. MUST INCLUDE FORMULAS of cell to cell calculations. Typed in answers will not be accepted.

2020 - 2021 Number Patient MRI Scans with current Equipment
TIME PERIOD	2020 Number of Patient MRI's	2021 Number of Patient MRI's	2022 Number of Patient MRI's
Fall	64	78	98
Winter	235	270	311
Spring	900	1008	1123
Summer	204	215	228
YEAR TOTAL:	1403	1571	1760