Correlation and Regression
Not what you're looking for?
Bus and subway ridership for the summer months in Paris, France, is believed to be tied heavily to the number of tourists visiting the city. During the past 12 years, the following data have been obtained:
Year(summer months) Number of Tourists(millions) Ridership(millions)
1 7 1.5
2 2 1
3 6 1.3
4 4 1.5
5 14 2.5
6 15 2.7
7 16 2.4
8 12 2
9 14 2.7
10 20 4.4
11 15 3.4
12 7 1.7
a) Plot these data and decide if a linear model is reasonable.
b) Develop a regression relationship.
c) What is expected ridership if 10 million tourists visit Paris in a year?
d) Explain the predicted ridership if there are no tourists at all.
e) What is the standard error of the estimate?
f) What is the model's correlation coefficient and coefficient of determination?
Work must be completed in Excel.
Purchase this Solution
Solution Summary
Develops a regression equation and determines the standard error, coefficient of correlation and coefficient of determination.
Purchase this Solution
Free BrainMass Quizzes
IPOs
This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)
Business Ethics Awareness Strategy
This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.
Motivation
This tests some key elements of major motivation theories.
Basic Social Media Concepts
The quiz will test your knowledge on basic social media concepts.
Introduction to Finance
This quiz test introductory finance topics.