What would be the predictive losses for $2024?$ You must use the Data Analysis Regression tool found in Excel. You dont need to calculate the incident rate or the severity rate, just the total losses. Provide the formula you used after generating the regression table in Excel.  

Transcribed Image Text:

Claims Forecasting Worksheet for Enter Company Name Accident Year Period Claims Frequency Total Average Losses Severity 2019 1 7 $ 106,680.00 $ 15,240.00 2020 2 9 $ 159,000.00 $ 17,666.67 2021 3 10 $ 186,500.00 $ 18,650.00 2022 4 15 $ 331,300.00 $ 22,086.67 2023 5 25 $ 495,600.00 $ 19,824.00 Claims Forecasting Worksheet for Enter Company Name Accident Year Period Claims Frequency Total Average Losses Severity 2019 1 7 $ 106,680.00 $ 15,240.00 2020 2 9 $ 159,000.00 $ 17,666.67 2021 3 10 $ 186,500.00 $ 18,650.00 2022 4 15 $ 331,300.00 $ 22,086.67 2023 5 25 $ 495,600.00 $ 19,824.00