User Account

All Pages

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

  The mean is a very useful measure

Describe a circumstance when the mean is a very useful measure and a circumstance when it is misleading

  Confidence interval for the true average

In a certain region of the country, average radar echo duration of lightning flashes is .61 sec and a standard deviation of .24 sec. Note, that these are population values. Calculate a 95% (two sided) confidence interval for the true average ..

  Single sample hypothesis testing - z-tests

Compute the single-sample z-test to see if caffeine reduces dreamtime. Test the null hypothesis at the .05 level of significance.

  Interpreting statistical data

The researchers used the available survey data and summarised the nature of the car accidents and if a mobile phone was being used by the driver either during (or immediately before) the accident

  Systolic and diastolic blood pressure of femalesthe

systolic and diastolic blood pressure of femalesthe following table represents systolic and diastolic blood pressure

  1 the test averages for 40 students are listed below use 8

1 the test averages for 40 students are listed below. use 8 classes not bins to construct a frequency distribution

  1 in this exercise we will be building regression models

1. in this exercise we will be building regression models for predicting house prices. we will be using data collected

  Develop a pareto chart

Develop a Pareto chart to identify the more significant types of rejection.

  Calculate the mean-median and standard deviation

Calculate the mean, median, and standard deviation and get statistics on the original reaction time, separately for the three stimulus types. Comment on how the means compare for the three stimulus types.

  Calculating a z-score and graphing a box plot

Calculating a Z-score and graphing a box plot and Statistical Inference of Sample Mean , Binomial Distribution and Regression Analysis

  Descriptive statistics - find the relation of question

Find the relation of question with some of the factors you think important as motivators of choosing the medical profession. Why do you choose these factors?

  Explain why ground-wave propagation is more effective

a) Explain why ground-wave propagation is more effective over sea water than dessert terrain. b) Why do stations in the AM broadcast band always use vertically polarized antennas

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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