Question: . A 2012 survey conducted by Idea Works provided data showing the percentage of seats available when customers try to redeem points or miles for

.A 2012 survey conducted by Idea Works provided data showing the percentage of seats available when customers try to redeem points or miles for free travel. For each airline listed, the column labeled 2011 Percentage shows the percentage of seats available in 2011 and the column labeled 2012 shows the corresponding percentage in 2012(The Wall Street Journal, May 17, 2012). UseAirlineSeats.xlsx

a)Develop a scatter diagram with 2011 Percentage as the independent variable and fit the regression line. Label the axis appropriately

b)What does the scatter diagram developed in part (a) indicate about the relationship between the two variables?

c)Using Data Analysis ToolPak develop the estimated regression equation.

d)Test for a significant relationship. Use 0.05 level of significance

e)Did the estimated regression equation provide a good fit?

f)Construct a residual plot. Comment on the shape of the plot as well as any unusual looking points.

.A 2012 survey conducted by Idea Works provided data showing the percentage

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

A 2012 survey conducted by Idea Works provided data showing the percentage of seats available when customers try to redeem points or miles for free travel. For each airline listed, the column labeled...

Using the U.S. Securities and Exchange Commission?s EDGAR database, select a public company that has consolidated subsidiaries. To minimize the chances of classmates selecting the same company,...

Read the entire Reading (scholastic journal article) completely and thoroughly. 2. Summarize the major points of the assigned reading . Here, I am looking for a detailed executive summary in which...

It is important to review HBR case - Olynpic rent a car case to solve this. Gold Silver Bronze Total All Renters Only Non- Medalists Enterprise Number of Cars Average Days Each Car Is Rented 63 146...

CASE 25 Southwest Airlines in 2014: Culture, Values, and Operating Practices Arthur A. Thompson John E. Gamble The University of Alabama Texas A&M University-Corpus Christi n 2014, Southwest Airlines...

HI GOOD AFTERNOON, IS IT POSSIBLE THAT I MAY GET SOME ASSISTANCE WITH THIS ASSIGNMENT. SEE ATTACHMENT INSTRUCTIONS ARE AS FOLLOWS: ONLY THE RELEVANT HISTORY IS IMPORTANT, IN TERMS OF A PROBLEM...

what is their strategy formulation and stategy implementation ?? C-30 CASE 16 Southwest Airlines Andrew Inkpen You are now free to move about the country" In 2013, Southwest Airlines (Southwest), the...

can you please guide me in writing a complete report on the case study; "United Airlines: Frequent Flyer Program", which includes demand analysis, critical analysis and financial analysis. Also,...

UNITED AIRLINES: FREQUENT FLYER PROGRAM1 Wong-Yong Oh wrote this case solely to provide material for class discussion. The author does not intend to illustrate either effective or ineffective...

Exercises 7, 8, and 9 are all tests of forecast optimality under quadratic loss function. Summarize all previous results and write a brief report explaining whether the Fed produces optimal forecasts...

Consider a 32-bit microprocessor, with a 16-bit external data bus, driven by an 8-MHz input clock. Assume that this microprocessor has a bus cycle whose minimum duration equals four input clock...

Case Scenario Equity for Expertise: Navigating Investment and Partnership in a Plastic Surgery Venture Background: As a startup consultant, you are advising a client who is a high respected...

A company issues 1,050 shares of its common stock for $33,600 cash. Prepare journal entries to record this event under each of the following separate situations.