Solution-Prepare a line graph comparing the linear trend

Prepare a line graph comparing the linear trend predictions

Assignment Help Applied Statistics

Reference no: EM13667383

Case - Time Series Forecasting

Refer to the data in the file below representing two years of monthly health insurance claims for a self-insured company.

Use regression analysis to fit a linear trend model to the data set.

a. What is the estimated regression function?

b. Interpret the R2 value for your model.

c. Prepare a line graph comparing the linear trend predictions against the original data.

d. What are the forecasts for each of the first six months in 2011 using this technique?

e. Calculate multiplicative seasonal indices for each month using the results of the linear trend model.

f. Use the seasonal indices to compute seasonal forecasts for the first six months in 2011.

g. Calculate additive seasonal indices for each month using the results of the linear trend model.

h. Use these seasonal indices to compute seasonal forecasts for the first six months in 2011.

Attachment:- HealthClaims.xls

Reference no: EM13667383

Questions Cloud

Which of the following is not required by irca : Which of the following is not required by IRCA

Compute the mass percent molality : A 1.37M solution of citric acid (H3C6H5O2) in water has a density of 1.10 g/cm^3. Compute the mass percent, molality, molefraction and normality of the citric acid. Citric acid has three acidic protons.

Explain what is the osmotic pressure of a solution : Solution A and B have osmotic pressures of 2.4atm and 4.6atm respectively at certain temperature. Explain what is the osmotic pressure of a solution organized by mixing equal volumes of A and B at the same temperature

What are the limitations on the values of the numbers : What is the name of each of the three quantum numbers used to describe orbital's in atoms. What orbital characteristics does each quantum number describe. What are the limitations on the values of these numbers

Prepare a line graph comparing the linear trend predictions : Prepare a line graph comparing the linear trend predictions against the original data and what are the forecasts for each of the first six months in 2011 using this technique?

Compute the frequency in hz and the energy : Compute the frequency in Hz and the energy in J using c= λv and c=2.998 x 108 m.s -1 and h=6.626 x10-34 J.s wavelengths used- 600nm, 400 nm, 450nm

Compare the heats of combustion of sugar : Explain why compare the heats of combustion of sugar or chicken fat measured in a bomb calorimeter with the caloric content of those foods

How long to review and consider the agreement : When a reduction in force occurs, the ADEA allows that protected employees may waive their rights under some circumstances. For the waiver to be valid, the protected employee must be allowed how long to review and consider the agreement?

Compute the volume of the glass bottle to the correct number : Explain a small empty glass bottle is found to weigh 6.820g. The container when filled with DI water at 20.00 degree Celsius weighs 32.628g. The density of water at 20.00 degree Celsius is 0.99821 g/mL.

User Account

All Pages

Prepare a line graph comparing the linear trend predictions

Reference no: EM13667383

Reference no: EM13667383

Questions Cloud

Reviews

Write a Review

Applied Statistics Questions & Answers

Hypothesis testing

Calculate the maximum reduction in the standard deviation

Calculate the expected value, variance, and standard deviati

Determine the impact of social media use on student learning

Unemployment survey

Statistical studies

Evaluate the expected value of the total number of sales

Statistic project

Simple data analysis and comparison

Analyze the processed data in statistical survey

What is the probability

Frequency distribution

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT