Use a single excel file with formulas within answer cells. Show formulas on exce file in the cells The ticketing office at a professional sports venue has noticed that ticket sales seem to fluctuate. The manager wants to introduce the strategy of demand-pricing in order to maximize attendance and therefor revenue. Based on historical sales, manager wonders if there is a connection between winning percentage (in decimal form) of the team and attendance (seats). Attendance (seats) Winning Percentage (decimal form) 78,000 0.6 89,000 0.67 93,000 0.7 59,000 0.5 65,000 0.55 97,000 0.9 86,000 0.6 75,000 0.55 91,000 0.8 61,000 0.52 Run a regression analysis. What is the regression equation? Is the model statistically significant at the 0.05 level?
Use a single excel file with formulas within answer cells. Show formulas on exce file in the cells The ticketing office at a professional sports venue has noticed that ticket sales seem to fluctuate. The manager wants to introduce the strategy of demand-pricing in order to maximize attendance and therefor revenue. Based on historical sales, manager wonders if there is a connection between winning percentage (in decimal form) of the team and attendance (seats). Attendance (seats) Winning Percentage (decimal form) 78,000 0.6 89,000 0.67 93,000 0.7 59,000 0.5 65,000 0.55 97,000 0.9 86,000 0.6 75,000 0.55 91,000 0.8 61,000 0.52 Run a regression analysis. What is the regression equation? Is the model statistically significant at the 0.05 level?
Algebra & Trigonometry with Analytic Geometry
13th Edition
ISBN:9781133382119
Author:Swokowski
Publisher:Swokowski
Chapter3: Functions And Graphs
Section3.5: Graphs Of Functions
Problem 81E
Related questions
Question
Use a single excel file with formulas within answer cells. Show formulas on exce file in the cells
- The ticketing office at a professional sports venue has noticed that ticket sales seem to fluctuate. The manager wants to introduce the strategy of demand-pricing in order to maximize attendance and therefor revenue. Based on historical sales, manager wonders if there is a connection between winning percentage (in decimal form) of the team and attendance (seats).
Attendance (seats) |
Winning Percentage (decimal form) |
78,000 |
0.6 |
89,000 |
0.67 |
93,000 |
0.7 |
59,000 |
0.5 |
65,000 |
0.55 |
97,000 |
0.9 |
86,000 |
0.6 |
75,000 |
0.55 |
91,000 |
0.8 |
61,000 |
0.52 |
- Run a
regression analysis . What is the regression equation? - Is the model statistically significant at the 0.05 level?
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 4 steps with 1 images
Recommended textbooks for you
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
Calculus For The Life Sciences
Calculus
ISBN:
9780321964038
Author:
GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.
Publisher:
Pearson Addison Wesley,
Elementary Algebra
Algebra
ISBN:
9780998625713
Author:
Lynn Marecek, MaryAnne Anthony-Smith
Publisher:
OpenStax - Rice University
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
Calculus For The Life Sciences
Calculus
ISBN:
9780321964038
Author:
GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.
Publisher:
Pearson Addison Wesley,
Elementary Algebra
Algebra
ISBN:
9780998625713
Author:
Lynn Marecek, MaryAnne Anthony-Smith
Publisher:
OpenStax - Rice University
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt