Business Finance Homework Help

First, you need to analyze the overall attitudes toward the two companies of your
choice (Xbox and PlayStation). Also, what should/could the companies do based on these hypothetical results?
In order to examine consumers’ overall attitudes toward Xbox, you calculate the average score for
Q1, Q2, and Q3, for each response (each row in the CSV file means 1 Response). Let’s say that
the average score for Response #1 is 7, the average score for Response #2 is 7, and the average
score for Response #3 is 6. The average for the (overall) attitudes toward Xbox is 6.67
((7+7+6)/3). Next, you do the same for the overall attitudes toward PlayStation (calculate the average
score for Q7, Q8, Q9). Let’s say that the average score for Response #1 is 4, the average score
for Response #2 is 3, and the average score for Response #3 is 2. Thus, the average for the
overall attitudes toward PlayStation is 3 ((4+3+2)/3). Consequently, it appears that consumers’ overall
attitudes toward Xbox are more favorable as opposed to its competitor PlayStation.

B. Second, you need to examine whether, on average, women expressed more favorable
attitudes toward the first brand (in my case, Xbox), when compared to their male
counterparts. Also, what should/could the company do based on these hypothetical
results?
You need to look at female participants’ responses to Q1, Q2, and Q3. Supposedly, the average
score for attitudes toward Xbox, for female respondents, is 7 and the average score, for male
respondents, is 3, then you can conclude that female consumers’ attitudes toward Xbox are more
favorable than their male counterparts.

C. Third, you need to examine if, on average, consumers with higher (versus lower)
income levels reported more/less favorable attitudes toward the first brand (in my case, Xbox). Also, what should/could the company do based on these hypothetical results?
How do you determine higher versus lower-income participants?

You can group the responses
based on the selected higher/lower income brackets. Let’s say you have:

Response 1 with 30.000 -39.999

Response 2 with 20.000 -29.999

Response 3 with 80.000 – 89.999

Response 4 with 90.000 – 99.999

Therefore, you can group Responses 1 and 2 as the lower-income level and Responses 3 and 4 as
the higher income level. Now, supposedly, the average score of attitudes toward Xbox, for higher-income individuals, is 6 compared to 4 (the average score for lower-income individuals).
Therefore, it appears that consumers who reported higher income levels may have a more
favorable attitude toward this company.

D. Fourth, you need to examine if, on average, older consumers reported more/less
favorable attitudes toward the first brand (in my case, Xbox), as opposed to their
younger counterparts. Also, what should/could the company do based on these
hypothetical results?
You can group the older/younger groups similar to the income groups. Further, let’s say that the
average score of attitudes toward Xbox, for those respondents who selected 50 or older, are more
favorable than those who reported being younger than 50.

The link Below Contains data.

https://docs.google.com/spreadsheets/d/1ZpVULtb0Kk…

Recap – Analyze the bogus data provided by Dr. D. This analysis should be included in the Word
doc that contains your survey (see STEP 3: A, B, C, D described above).

A. First, you need to analyze the overall attitudes toward the two companies of
your choice. Also, what should/could the companies do based on these
hypothetical results?

B. Second, you need to examine whether, on average, women expressed more
favorable attitudes toward your favorite company, when compared to their male
counterparts. Also, what should/could the company do based on these
hypothetical results?

C. Third, you need to examine if, on average, consumers with higher (versus
lower) income levels reported more/less favorable attitudes toward your favorite
company. Also, what should/could the company do based on these hypothetical
results?

D. Fourth, you need to examine if, on average, older consumers reported more/less
favorable attitudes toward your favorite company, as opposed to their younger
counterparts. Also, what should/could the company do based on these
hypothetical results?