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.

Reviews

Write a Review

 

Applied Statistics Questions & Answers

  Is the random variable discrete or continuous

Is the random variable discrete or continuous?

  Determine the correlation coefficient

Determine the correlation coefficient. Find the predicted value of Y given X = 75. Give an interpretation of the predicted value in the context of the problem.

  Forecasting with time series analysis

Develop a sales forecast for each store for December Plot the data for each store.Use data in table.

  Calculate the sample size needed given these factors

Calculate the sample size needed given these factors

  Perform a hypothesis testing

The company wants to perform a hypothesis testing. Which of the following are the right hypotheses and what is the α-risk associated with the x' chart?

  Descriptive statistics

Descriptive statistics (5-number summary, mean, mode, range and standard deviation) for each of the four variables along with an explanation of what the descriptive statistics tell us about the motion picture industry.

  Business research report proposal

A business research topic - Strengthen and improve initial proposal and research questions for the identified problem or opportunity

  Writenbspa 2 page critique of an online user manual you can

writenbspa 2 page critique of an online user manual. you can download a usernbspmanualuser guide for a product of your

  Information and the research study

Please read through the case scenario shown below to gain an understanding of the background information and the research study

  Correlation between the number of days of class missed

An analysis was done to see if there was a correlation between the number of days of class missed and a student's GPA.

  Calculate a 90 percent confidence interval

Using the information from part  by hand, calculate a 90 confidence interval for the difference of the means for the two time periods.

  Compute the quarterly forecasts for next year

Use a regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data.  Qtr1 = 1 if Quarter 1, 0 otherwise; Qtr2 = 1 if Quarter 2, 0 otherwise; Qtr3 = 1 if Quarter 3, 0 otherwise.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd