I have also attached a sample xls file that contains the 5 steps referred to in the word doc. The data is located in the movie.xls file.
Develop a regression model for movie demand. Follow the five steps outlined in the sample XLS file.
? Accomplish a correlation table and scatter plots with trend lines of all of the variable data: price, DVD rental price, DVD purchase price, popcorn price, and income versus demand.
? Do a linear regression of all of the data.
? Based on your interpretation of your trend line outcomes, do a data transformation of the variables and regression.
? Write out the regression equations for the linear and transformed models.
? Use your equations to calculate predicted demand values.
? Analyze the coefficients in your model using the confidence level test of p-values. Are they statistically different from zero based on passing the 95% confidence level test?
? Analyze the models overall based on Sig F values. Are they statistically different from zero based on passing the 95% confidence level test?
? How well do the models capture the variability in demand based on their R Square values?
Step by step method for computing regression model for movie data set.
Regression analysis in SPSS ..
An experiment involves three treatment groups; group A, group B and a control group
(i.e. no treatment). Three hundred subjects are randomly assigned to the groups creating
three groups of one hundred.
a. If the experimenter wants the regression slopes to compare each treatment mean
to the control group mean, how should the codes be set up? Are they orthogonal?
b. If the experimenter wants to perform the following comparisons, how should the
codes be set up? Are these orthogonal?
1. Treatment vs No Treatment
2. Treatment A vs Treatment B
The school board of a particular town wants to compare the three high schools in the
town. A multiple regression analysis is conducted using the contrasts shown below. Use
the means table also shown to find the prediction equation: ) 2 c ( b ) 1 c ( b b Yˆ i = 0 + 1 + 2 , i.e.
find the values of b0, b1, and b2. Describe (in a sentence each) the meaning of the
coefficient of c1 and c2.
c1 c2 Mean SAT N
School 1 1 1 School 1 992 100
School 2 -2 0 School 2 988 100
School 3 1 -1 School 3 986 100
A researcher is interested to know if playing a musical instrument has a significant effect
on grade point average (gpa). She records whether or not a student plays an instrument
and their gender.
Using the data, run the appropriate analysis and interpret the results. Include the group
means and a plot of these (i.e. a graph of the interaction or non-interaction) in your
interpretation as well as a separate effects ANOVA table.
A company is interested in ways of improving employee production. The management
decided to attempt to increase company pride and moral by providing one day a month
that would be different from a normal work day. They could not decide if this day should
include some sort of work related activities (such as training or other workshops, group
A) or if the day should be purely social (trips to the movies or a museum, group B). The
research department randomly assigned 15 people to each group. They also recorded
each worker's salary. Using the data, perform the appropriate analysis in SPSS.
Summarize the results.