Several documents have been uploaded under Week #12 to help you with Chapter 11/12 and Assignment #5. Be sure the review carefully. The discussion posting will also help you with this assignment. (1) Microsoft Excel for Statistical Analysis – Click hereUsing 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 testinghttps://www.youtube.com/watch?v=p8dz1znP5_g – Descriptive statisticshttps://www.youtube.com/watch?v=g_PH5FKBJJY – Correlation & regressionhttps://www.youtube.com/watch?v=z7kMeJQWr4Y – Correlation & regression(2) Excel spreadsheet on survey respondents – Click hereThe 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.How many males and females responded to the survey (x32)? (1 pt)What percentage saw an ad of Santa Fe in the past 60 days (x31)? (1 pt)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)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)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)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)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)What do the results of the linear regression mean? Does satisfaction affect likelihood to return? (2 pts)What is the R-square? (1 pt)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?
Why Choose Us
- 100% non-plagiarized Papers
- 24/7 /365 Service Available
- Affordable Prices
- Any Paper, Urgency, and Subject
- Will complete your papers in 6 hours
- On-time Delivery
- Money-back and Privacy guarantees
- Unlimited Amendments upon request
- Satisfaction guarantee
How it Works
- Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
- Fill in your paper’s requirements in the "PAPER DETAILS" section.
- Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
- Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
- From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.