null

MKT572 Group Project

There are several requirements for group project. Failure to meet the submission requirement will result in a deduction of 10 points from your grade.

1. All datasets are already uploaded in the group project module. You don’t need to go to publisher’s website to download them.

2. Question 1 of Chapter 15 use the file titled ” program file. movie. attendance. with errors. sav”. The other questions use the file “program file.movie attendance. sav”. Chapter 15, EX1 requires you to use the SPSS movie data with error. This is the only exercise that needs to be done using the data with errors.

3. In your cover page, list the full name of all group members, course number and section number.

4. Only one group member is required to submit the group project.

5. Only word file is accepted. Please limit your assignment length within 25 pages.

6. Please copy and paste only relevant tables and figures into your word file.

7. Please use this template for your group reports. Please be noted that some questions are procedures. You don’t need to provide answers. For those questions requiring your answer, I put a “Answer:” below each question. You need to provide your answers to those questions. If I provide an example in the answer, you should follow my example. For some questions, I give answers directly. If I state that the answer is already provided, you don’t need to answer those questions.
8. If your group member does not finish his/her part or don’t respond to group emails, please notify me at least one week ahead of submission. I may eliminate this person from your group and let the person do the project alone. Please be noted that it is your group’s responsibility to submit a complete project report. Your grade is only based on the final report. If a person fails to finish his/her part, your group is responsible for the completion of the report. My suggestion is that everyone should finish all parts of the project and compare your answers inside group members.

9. In the end of the project, there is a peer evaluation form for you to fill in. Please read the instructions carefully. I don’t allow for any type of free rider behavior in group project. If you feel your group member does not deserve the credit, just let me know. It is possible that a particular member gets zero score due to lack of contribution.

10. Point Distribution 150 points

Chapter 15 EX.1 (20 points)

Chapter 15 EX.2 (30 points)

Chapter 15 EX.3 (30 points)

Chapter 15 EX.4 (20 points)

Chapter 16 EX.3 (20 points)

Chapter 18 EX.1 (30 points)

Chapter 15. P.391, SPSS Exercise 1(20 points)

EXERCISE 1: Machine Cleaning Data

1. Go to the Wiley Web site at

www.wiley.com/college/mcdaniel

and download the
Segmenting the College Student Market for Movie Attendance database to SPSS Windows. This database will have several errors for you to correct. In the SPSS Data Editor, go to the variable view option and notice the computer coding for each variable.

2. Also from the Wiley Web site, download a copy of the Segmenting the College Student Market for Movie Attendance questionnaire. Notice the computer coding for each of the variables, which is the same as that in the variable view option on the SPSS Data Editor. This information will be important in finding errors in the database.

3. In the SPSS Data Editor, invoke the analyze/descriptive statistics/frequencies sequence to obtain frequencies for all of the variables in the database.

4. From the SPSS Viewer output screen, determine which variables have input errors. Summarize the errors using the template below as a guide.

Answer:

Questionnaire Number

Variable Containing Error

Incorrect Value

Correct Value

82

Q1

2

1

Go back to the data view screen of the SPSS Data Editor:

5. Another possible source of errors is in question 8. Notice that in this question the sum of the answers should be 100 percent. Create a summated variable for question 8 (Q8a + Q8b + Q8c + Q8d) to check for errors invoking the transform/compute sequence. Now compute a frequency distribution for Q8sum. The values that are not “100″ indicate an input error. (Such an error could be the result of the respondent not totaling percentages to 100, but for this machine cleaning exercise, the assumption is that it is an input error). Summarize the errors using the template above.

Answer:

Questionnaire Number

Variable Containing Error

Incorrect Value

Correct Value

6. Once you have completed summarizing the variables containing errors, go back to the data view screen of the SPSS Data Editor. Position the cursor on each of the variables containing errors. Use the ctrl-f function to find the questionnaire numbers where the errors occurred. At this point, you will need the corrected or the database with no errors. Your professor has access to this database with no errors. After getting the corrected database, finish filling in the table in (4) above with the correct values. Then make the changes in your database, so that you have a database with no errors. Be sure to resave your database after correcting it for errors.

7. After machine cleaning your data, rerun the analyze/descriptive statistics/frequencies sequence to obtain frequencies for your corrected database.

8. You will use the results of this exercise to answer the questions in Exercises 2 and 4.

Note: You can just use the data set without error under doc sharing to finish the rest of the projects.

Chapter 15 SPSS Exercise 2(30 points)

EXERCISE 2: Analysis of Data with Frequency Distributions

Note: Use Percent (with missing value counting). Do not use valid percent (missing values are not counted).

1. What percentage of all respondents attended at least 1 movie in the past year?

Answer:

2. What percentage of all respondents never buy food items at a movie?

Answer:

3. Produce a table indicating the percentage of all respondents that consider each of the movie theater items in question 5 of the questionnaire very important. List the top 5 movie items in descending order (start with the movie items that have the highest percentage of the very important responses).

Answer: Using the template below to summarize your results.

Most Important Movie Theater Selection Factors

Rank

Selection Factor

Percentage favoring

1

Comfortable Chairs (Q5d)

63.00%

2

3

4

5

6

7

8

9

4. What percentage of respondents consider the “newspaper” a very important source of information about movies playing at movie theaters?

Answer:

5. What percentage of respondents considers the “Internet” a very unimportant source of information about movies playing at movie theaters?

Answer:

6. By observing the distribution of responses for Q8a, Q8b, Q8c, and Q8d, which is the most popular purchase option for movie theater tickets?

Answer:

7. Produce a table listing in descending order the percentage of respondents that consider each of the movie theater information sources (Q7) very important?

Answer:

Most Popular Sources for Movie Theater Information

Movie theater information source

Percent of Respondents Indicating Very Important

Internet

44.40%

Chapter 15 SPSS Exercise 3(30 points)

EXERCISE 3: Analysis of Data with Descriptive

On the questionnaire, question 5 utilizes a 4-point Itemized Rating scale (illustrated below). This scale is balanced and can be assumed to yield interval scale / metric data. Given the preceding, invoke SPSS to calculate the mean and standard deviation for all of the variables in 5 (Q5a – Q5i).

1. Using only the mean for each of the variables, which of the movie theater items was considered “most important”?

Answer:

2. Using only the standard deviation for each of the variables, for which question was there the greatest amount of agreement? Hint: Least amount of dispersion regarding the response to the movie item.

Answer:

3. Questions 4 and 6 utilize multiple-choice questions that yield nonmetric data but that are ordinal scale. The appropriate measure of central tendency for nonmetric data are the median and the mode.

a. What is the median response for question 4, concerning the amount a person spends on food / drink items at a movie?

Answer:

b. Concerning question 6, the distance a person would drive to see a movie on a “big screen,” what is the mode of that distribution of responses?

Answer:

4. In this question, the objective will be to compare the results of median and mean responses for Q3.

Answer:

a. Mean response:
b. Median response:
c. Standard deviation:
d. Minimum response:
e. Maximum response:

5. When the responses to a question contain extreme values, the mean response can lie in the upper or lower quartile of the response distribution. In such a case, the median value would be a better indicator of an average response than the mean value. Given the information you obtained from answering #4 above, is the mean or median a better representative of the “average” response to Q3?

Answer:

Chapter 15 SPSS Exercise 4 (20 points)

EXERCISE 4: Analysis of Demographic Characteristics Using Charts

If you completed Exercise #1 and/or Exercise #2 you will have the information to complete this exercise. If you did not complete either Exercise #1 or #2, you will need to get a corrected movie attendance database from your professor. After getting the database, use the analyze/descriptive statistics/frequencies sequence to obtain frequency distributions for the demographic questions (questions 11–14). Complete the following.

1. Display the demographic data for each of the four demographic variables in tables.

Answer: copy past the table from SPSS output below.

2. For each of the demographic variables, illustrate the table results using some type of graphic representation of the data (pie charts, line charts, or bar charts).

Answer: SPSS, Excel, Quattro Pro, and some word processing packages can accomplish the task. Copy past the charts below:

Chapter 16. P.436, SPSS Exercise 3 (20 points).

EXERCISE #3: ANOVA Test for Independent Samples

Invoke the analyze/compare means/One-Way ANOVA sequence to invoke the ANOVA test to complete this exercise. This exercise compares the responses of freshmen, sophomores, juniors, seniors, and graduate students to test for significant differences in the importance placed on several movie theater items. For the ANOVA test, SPSS calls the variable in which means are being computed the independent variable and the variable in which we are grouping responses the factor variable. Be sure to click the options icon and check descriptive so that the output will produce the mean responses by student classification for the sample data. As with the t test, the ANOVA test produces a table of descriptives based on sample data. If our ANOVA test is significant, the descriptives can be used to determine, for example, which student classification places the most importance on comfortable seats. From our sample data, can we generalize our results to the population by saying that there are significant differences across the classification of students by the importance they place on the following movie theater items?

Answer:

1. Video arcade at the movie theater (Q5a)? No. .548
2. Soft drinks and food items (Q5b)?
3. Plentiful restrooms (Q5c)?
4. Comfortable chairs (Q5d)?
5. Auditorium-type seating (Q5e)?
6. Size of the movie theater screen (Q5f)?
7. Quality of the sound system (Q5g)?
8. Number of screens at the movie theater (Q5h)?
9. Clean restrooms (Q5i)?

10. Using only descriptive statistics, which classification group (Q13) places the least amount of importance on clean restrooms (Q5i)?

Answer:

11. Using only the descriptive statistics, which classification group (Q13) places the greatest amount of importance on quality of sound system (Q5g)?

Answer:

Summarize the results of your ANOVA analysis using a table similar to the one below:

How important is the following when choosing a movie theatre…

DF

F

Sig

Interpretation

a) Video Arcade at the Movie Theatre

4, 442

0.766

.548

There are no significant differences between the classifications

Chapter 18. P. 496—498. SPSS exercise 1. (30 points).

EXERCISE 1: Multivariate Regression

This exercise uses Multivariate Regression to explain and predict how many movies a respondent attends in a month.

1. Download the Movie database.

2. Open the database in SPSS and view the variables under Variable View. We will be using the independent variables Q2, Q4, Q6, Q8a, Q8b, Q9, Q10, Q12, and Q13 to predict the dependent variable Q3. We are including the variables Q4 and Q6 as is. Strictly speaking, is this proper? What might you want to do instead and why? Why might you decide to leave the variable in bins instead? Would it ever be proper to use a variable like Q11 as is?

Answer (Please see below. You don’t need to answer this question).

Q4 and Q6 are ordinal scaled, whereas regression requires metric scaled predictors. The appropriate method would be to create three dummy variables for Q4 (it has four categories) and four dummy variables for Q6 (it has 5 categories). Q11 is nominally scaled. It would not be useful to try to apply numerical analysis to nominal data beyond a simple frequency analysis.
Q4 has four categories, so you can create three dummy variables.

Category / value

X1

X2

X3

Never buy food items at movies

0

0

0

Up to $7.49

1

0

0

$7.50 to $14.99

0

1

0

$15.00 or more

0

0

1

Q6 has five categories, so you can create four dummy variables.

Category / value

X1

X2

X3

X4

Zero

0

0

0

0

1 to 9 miles

1

0

0

0

11 to 24 miles

0

1

0

0

25 to 49 Miles

0

0

1

0

50+ miles

0

0

0

1

The data from question 11 is nominal. The categories are assigned arbitrary values, so the data is not useful for regression or many other types of quantitative analysis.

3. Go to analyze/descriptive statistics/descriptives and move Q3, Q2, Q4, Q6, Q8a, Q8b, Q8c, Q8d, Q9, Q10, Q12, and Q13 to the Variable(s) box and click OK. Multivariate techniques require that every variable have a legitimate value. If a respondent did not answer every question, then the analyst must either ignore the observation entirely or impute estimates for the missing values. The default for statistical software is to ignore those observations automatically. We will not do imputation for this exercise.

a. What will be the sample size for later multivariate techniques?

Descriptive

N

Minimum

Maximum

Mean

Std. Deviation

(Q3)On average, about how many movies do you attend at a movie theatre each month?

448

.0

12.0

1.576

1.2519

(Q2)Indicate how important you consider going to the movies at a movie theatre, relative to other leisure activities.

448

1

4

2.25

.803

(Q4)Not including the cost of the movie ticket, about how much do you spend on popcorn, candy, softdrinks, etc. at a movie?

449

0

3

.94

.748

(Q6)If your community did not have a “big screen” theatre, how much further would you drive beyond the cinema nearest to you to see a movie at a “big screen” theatre?

448

0

4

2.47

.821

(Q8a)Of all the movie tickets that you have ever purchased, what percentage were purchased: Via the Internet

446

0

95

7.11

16.177

(Q8b)Of all the movie tickets that you have ever purchased, what percentage were purchased: At the theatre right before the movie started

446

0

100

82.08

23.727

(Q8c)Of all the movie tickets that you have ever purchased, what percentage were purchased: At the theatre, but the movie played at a later time

446

0

100

10.06

17.167

(Q8d)Of all the movie tickets that you have ever purchased, what percentage were purchased: Using some other purchase option

446

0

30

.75

3.709

(Q9)How physically active do you consider yourself?

498

1

4

3.21

.723

(Q10)How Socially active do you consider yourself?

500

1

4

3.26

.749

(Q12)Gender:

500

0

1

.54

.499

(Q13)Classification:

500

1

5

3.10

1.239

Valid N (listwise)

442

Answer: 442 (answer provided)

b. Is this sample size large enough for multivariate regression?

Answer:

c. What would some possible problems be if the sample size were not large enough?

Answer:

d. Are the minimum and maximum values for each variable within the proper range?

Answer (provided):

Yes. A value that is out of range would indicate either a data input error or a user-defined missing value like “Refused” or “Don’t Know.” Data input errors should be corrected or deleted. User-defined missing values should be declared in SPSS.

e. Are all the variables within the proper range?

Answer:

4. Go to analyze/regression/linear.

Move Q3 to Dependent

Move Q2, Q4, Q6, Q8a, Q8b, Q8c, Q8d, Q9, Q10, Q12, and Q13 to Independent(s).

Change Method to Stepwise

Click OK

a. Which independent variables did the stepwise regression select? Why not the rest?

Answer:

b. Is each variable chosen significant?

Answer:

c. Are the variables that have not been chosen necessarily insignificant?

Answer:

d. Is the model significant?

Answer: you need to provide the necessary output and highlight the key number.

e. Does this method guarantee that you will get the “best” model?

Answer:

5. Go to analyze/descriptive statistics/descriptives and remove Q6, Q8a, Q8b, Q8c, Q8d, Q9, Q10, and Q12 from the Variable(s) box, so that only Q3, Q2, Q4, and Q13 remain in the box and then click OK.

What is the sample size now?

Answer:

6. Go to analyze/regression/linear

Move Q3 to Dependent

Remove Q6, Q8a, Q8b, Q8c, Q8d, Q9, Q10, and Q12 from Independent(s) so that only Q2, Q4, and Q13 remain.

Change Method to Enter

Click OK

Answer:

You need to present the ANOVA table and coefficients table.

a. How and why does this model differ from the model based on stepwise regression?

Answer:

b. Which model is better?

Answer:

INTERPRETATION

1. How does stated importance affect the number of times one attends movies?

Answer:

2. How does spending money on snacks affect the number of times one attends movies?

Answer:

3. How does student classification affect the number of times one attends movies?

Answer:

4. If a sophomore thought that going to movies was somewhat important and typically spent $12 on snacks, how many times per month would he or she attend movies based on this model?

Answer: using the following formula to calculate Y (i.e., Q3). The final answer should be 4.79.

Y

= a + b1X1 + b2X2 + b3X3 + . . . bnXn

5. Do any of the variables, according to the results, appear to have an effect on the number of times one attends movies, or does it seem that other factors not covered in this survey are driving movie

attendance?

Answer:

Group Evaluation Form:

For each group project, please fill in the group peer evaluation form under doc sharing. This form enables you to assign individual contribution of each of your group members and express your concerns freely. Please send it under Group project 1 basket.  For group project 2, also please fill in the same evaluation form and send it to Group project 2 basket.

If there is an unanimous agreement on the misbehavior of an individual member such as failure to accomplish his/her part or lack of cooperation, I will deduct points from this individual student.
The peer evaluation form is not mandatory. If you are satisfied with your group members, you don’t need to submit it and I will consider that your group members contribute equally.

5