Lesson10AClassActivity

.xlsx

School

Brigham Young University, Idaho *

*We aren’t endorsed by this school

Course

108X

Subject

Management

Date

Apr 3, 2024

Type

xlsx

Pages

44

Uploaded by Eleanoriclements on coursehero.com

Olivia's Honda Civic Which trend line is best for Insert a scatterplot of Olivia's data here. Estimated sales price of a 9 year-old Honda Civic: Estimated sales price of an 18 year-old Honda Civic: If necessary revisit the Olivia example from the Lesson 10 Rea Use your trendline equation to estimate, or predict, the sales price and a Honda Civic that is 18 years old. 0 2 4 6 8 10 12 14 16 18 $0.00 $2,000.00 $4,000.00 $6,000.00 $8,000.00 $10,000.00 $12,000.00 $14,000.00 $16,000.00 $18,000.00 $20,000.00 f(x) = 18421.8364737423 exp( − 0.099893637138979 x ) Sale Price
Olivia's data? Olivia's Data Input Variable Output Variable Age of Car Sale Price 0 $18,900.00 1 $16,000.00 3 $12,995.00 4 $11,900.00 6 $10,299.00 7 $9,400.00 8 $9,190.00 13 $4,950.00 14 $4,650.00 17 $3,200.00 $7,489.83 $3,045.14 of a Honda Civic that is 9 years old
Input Variable: Team Payroll Output Variable: Win Percentage Follow this link to the textbook to review steps for creating a trendline in Excel: Billy and Brad are brothers who are obsessed with baseball. They want to predict which teams will win based on the team payroll. They assume that better payers earn more money. Therefore they believe that teams with high payrolls are more likely to win. They want to use data to see if their belief is valid. They plan to create a trendline to predict winning percentage based on total payroll. Determine the input and output variables for this situation: Billy and Brad find the following data for the last few years for Major League Baseball teams in the United States. Create a scatterplot of the data. Then determine which type of trendline is most appropriate for this data. Add the trendline to your scatterplot. http://www.byuimath.com/fdmat108/Lesson9.html#excel_instructions_-_trendlines Billy's favorite team is the Oakland A's. In 2018, the Oakland A's payroll was a total of $50.7 million. Brad's favorite team is the New York Yankees. In 2018, the Yankee's payroll was a total of $158.5 million. Use your trendline equation to predict the winning percentage for each team.
Oakland A's predicted winning percentage: 75.81526 NY Yankee's predicted winning percentage: 90.0233 percentage for each team. Does the scatterplot and trendline support Billy and Brad's assumption that teams with high payrolls are likely to win a greater percentage of their games than teams with lower payrolls? Why or why not? If roughly supports Billys and Brads assumption because the graph follows a line going upward roughly.
If the Data did not folllow a pattern and it was all over the place. What kind of situation would lead Billy and Brad to re-evaluate their reasoning?
Win Percentage Insert Scatterplot here 216.10 93.33 146.66 92.33 127.40 91.33 119.57 84.67 115.16 82.67 114.40 94.33 110.05 75.67 108.16 85.67 103.53 83.67 102.60 88.67 101.81 82.33 101.69 80.33 94.20 73.00 92.44 78.33 Team Payroll (in millions of dollars) 30 40 50 60 70 80 90 100 f(x) = 0.131817335115894 x + 69 Win Per
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help