Business Finance Homework Help

Below i have attached the survey questions and the excel.

Using Microsoft Excel for Statistical Analysis provides you with the “how to” on using Excel for statistical analysis. Several Youtube videos are also available. I particularly like –

https://www.youtube.com/watch?v=VK-rnA3-41c – Hypothesis testing

https://www.youtube.com/watch?v=p8dz1znP5_g – Descriptive statistics

https://www.youtube.com/watch?v=g_PH5FKBJJY – Correlation & regression

https://www.youtube.com/watch?v=z7kMeJQWr4Y – Correlation & regression

(2) Excel spreadsheet on survey respondents – Click here

The Excel spreadsheet is a compilation of the data collected. The sample size is N=405.The top row corresponds with each question asked in the survey (pp. 225-230) and is defined as follows:

Id – Customer #

x_s1 to s4 – Screening questions (Exhibit 8.7: #1-#4)

X1 to X11 – Lifestyle questions (Exhibit 8.8: #1-#11)

X12 to X21 – Perception questions (Exhibit 8.8: #12-#21)

X22 to X25 – Relationship questions (Exhibit 8.8: #22-#25)

X26 to X29 – Selection Factors (Exhibit 8.8: #26-#29)

X30 to X35 – Classification questions (Exhibit 8.8: #31-#36)

IMPORTANT NOTE: Question #30 (social media) was omitted in this analysis. Therefore, variable X30 corresponds with Question #31 in the survey. X31 with Q#32; X32 with Q#33; X33 with Q#34; X34 with Q#35 and X35 with Q#36.

Assignment Questions:

Read the questions carefully before you start using Excel to generate your answers.

1. How many males and females responded to the survey (x32)? (1 pt)
2. What percentage saw an ad of Santa Fe in the past 60 days (x31)? (1 pt)
3. How many sample respondents have recently eaten at Santa Fe? What was the average (use mean, median or mode) distance traveled by Santa Fe customers only (x30)? (HINTS – Read the question carefully, examine the measurement scale & consult p. 300) (2 pts)
4. For Santa Fe recent customers only, what is the mean, median and mode for x13? Based on the results, is Santa Fe considered a fun place to eat? Explain your answer. (HINTS – Read the question carefully & consult p. 300) (3 pts)
5. For Santa Fe recent customers only, what is the mean, median and mode for x22? Based on the results, is the sample satisfied of Santa Fe? Explain your answer. (HINTS – Read the question carefully & consult p. 300) (3 pts)
6. For ALL survey respondents, what is the correlation (r) between fun place to eat and satisfaction? Is the correlation significant? What does your answer mean? (HINT – Refer to the Module on Statistical Analysis) (3 pts)
7. For ALL survey respondents, conduct a linear regression analysis with x22 as the independent variable and likelihood to return (x23) as the dependent variable. Run the statistical regression analysis. Write the linear equation for this regression analysis based on the results. Make sure you write the specific name of the variables representing your X and Y. (3 pts)
8. What do the results of the linear regression mean? Does satisfaction affect likelihood to return? (2 pts)
9. What is the R-square? (1 pt)
10. What does the R-square mean with regards to satisfaction and likelihood to return? (1 pt)

BONUS: (5 pts)

For Santa Fe recent customers only:

Bonus #1: What is the correlation between fun place to eat & satisfaction?

Bonus #2: What is the equation of the line of X22 affecting X23?