Question: need a reggression 1. Using the data below and SPSS, run a regression analysis to determine whether bus and trolley ridership demand is tied to

need a reggression need a reggression 1. Using the data below and

1. Using the data below and SPSS, run a regression analysis to determine whether bus and trolley ridership demand is tied to the number of tourists visiting the city on an annual basis. During the past 10 years, the Ty Ty, Georgia Department of Tourism obtained the following data: Number of Tourists (1,000,000's): 5, 6, 5, 7, 14, 15, 16, 12, 15, 21, 14, 7. Ridership (100,000's): 15, 15, 19, 15, 25, 27, 20, 20, 27, 42, 33, 12. 2. Write the prediction equation (Y - bo + bx). 3. Write an explanatory paragraph (not to exceed one page: double-spaced) addressing the results of your regression model by commenting on the following parameters and issues: Omnibus F-test (indicates overall status of model) R!(coefficient of determination) (coefficient of correlation) Significant predictor If there are no tourists at all, what is the predicted ridership? What is the predicted ridership if 7 million people visit the city

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 General Management Questions!

Two - Chapter Three (six problems) Due: 11/12 #1 Accountants at the firm Walker and Walker believed that several traveling executives submit unusually high travel vouchers when they return from...

4-13 Students in a management science class have just received their grades on the first test. The instructor has provided information about the first test grades in some previous classes as well as...

The MAD for Method 1=______thousands gallons (round your response to three decimal places) The mean squared error (MSE) for Method 1=______thousands gallons^2(round your response to three decimal...

ORMATIVE ASSESSMENT 2 [100 Marks] Answer ALL the questions in this section. O Question 1 la Study the information provided below on the research background, the aim and research objectives of a...

Complete Problems 4-13, 4-14, 4-15, and 4-19. Use Excel's regression option to perform the regression. Use an Excel spreadsheet file for the calculations and explanations, with one worksheet per...

B) If it is decided that a factor 2 (Degree to which the population can converse in English) is not a necessity, then the best location is _________, with a total weighted score of ___. (Enter...

Problem 1. (25 points) Bus and subway ridership for the summer months in London, England, is believed to be tied heavily to the number of tourists visiting the city. During the past 12 years, these...

Caf Michigan's manager, Gary Stark, suspects that demand for mocha latte coffees depends on the price being charged. Based on historical observations, Gary has gathered the following data, which show...

4-19 Bus and subway ridership in Washington, D.C., dur-ing the summer months is believed to be heavily tied to the number of tourists visiting the city. During the past 12 years, the following data...

Companies X and Y have been offered the following rates per annum on a $50 million 5-year loan: Fixed Rate Company X Company Y Floating Rate LIBOR + 0.2% LIBOR + 0.5% 3.40% 4.40% Company X requires a...

What are the sanctions for not complying with the PRI?

Stormy and Daniel are working on the audit of McBride LLC , an international retailer of farm equipment and other heavy machinery.Stormy and Daniel have been tasked by their supervisor to audit the...

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...