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

Report
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.
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
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
88.62 85.33 83.43 69.00 80.10 78.00 73.72 82.67 73.22 75.33 70.97 82.67 70.83 80.00 68.22 81.33 67.66 85.00 67.28 87.67 64.74 80.00 61.01 68.67 56.81 67.67 48.52 67.33 39.76 74.67 27.07 77.67 0 50 100 0 10 20
References: PBS Nova Info (37:20-40:00):
9.1332018402678 centage
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
150 200 250
www.sportrac.com/mlb seanlahman.com/baseball-archive/statistics http://www.pbs.org/wgbh/nova/phy
Input Variable: Month Number Output Variable: Total Number of Cars Sold Follow this link to the textbook to review steps for creating a trendline in Excel: Juanita sells cars for a car dealership. Her pay is based on the n sells each month. She wants to take a couple of weeks off for va to find the month when car sales will be slowest. Juanita assumes that the number of cars she sells per month wi trend as national car sales. She wants to create a trendline to p of car sales based on the month. She also assumes that this yea similar to last year's sales. Determine the input and output variables for this situation: Juanita finds this data for the number of car sales for March of l February of this year. Create a scatterplot of the data. Then determine which type of appropriate for this data. Add the trendline to your scatterplot. http://www.byuimath.com/fdmat108/Lesson9.html#excel_instructions_-_trendli Juanita is thinking of going on vacation in either April or Septem predict how many cars will be sold nationwide in April and Sept Because she listed April as month 2 and September as month 7, equation to find the predicted value for months 2 and 7.
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
Predicted cars sold in month 2 (April): Predicted cars sold in month 7 (September): 4.83603557957552 Month 5 looks best- July When is the airfare is cheapest. equation to find the predicted value for months 2 and 7. The vertex of the parabola shows Juanita the month with the lo the formula x = -b/(2a) to find the x-coordinate of the vertex of the table on the right to see which month corresponds to the x- vertex. When should Juanita take her vacation? What other things should Juanita consider, other than potential deciding the month for her vacation?
Month Number Insert Scatterplo 1 207717 2 209493 3 206083 4 207547 5 200303 6 200100 7 204441 8 209288 9 215730 10 213341 11 217663 12 220591 number of cars she acation and wants ill follow the same predict the number ar's sales will be last year through trendline is most . Total Number of Cars Sold ines mber. She wants to tember of this year. , use the trendline 200000 205000 210000 215000 220000 225000 f(x) = 3
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
206997.84 205804.04 Month Name Month Number March 1 April 2 May 3 June 4 July 5 August 6 September 7 October 8 November 9 December 10 January 11 February 12 owest car sales. Use the parabola. Use -coordinate of the l car sales, when 0 2 185000 190000 195000
ot here 355.264985014985 x² − 3436.06368631368 x + 212448.977272727 Total Number of Cars Sold
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
4 6 8 10 12 14
References: https://www.census.gov/retail/index.html
Input Variable: Price of Artwork Output Variable: Number of Artwork Sold Follow this link to the textbook to review steps for creating a trendline in Excel: Marti and Val are artists. They spent last summer selling their art festivals. They also kept track of their sales. They want to figure out how many works to create and the best art this summer to maximize their profits. Marti and Val want to create a trendline to predict the number o based on the price. They would like a function relating the price of art works sold. They assume that this summer's sales will be s summer's sales. Determine the input and output variables for this situation: Marti and Val changed their prices several times and collected d Create a scatterplot of the data. Then determine which type of t appropriate for this data. Add the trendline to your scatterplot. http://www.byuimath.com/fdmat108/Lesson9.html#excel_instructions_-_trendlin
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
Predicted art works sold if the price is $15.00: Predicted art works sold if the price is $45.00: Type your answer here Marti and Val are thinking of pricing their art at either $15 dollar want to predict how many art pieces they will sell at these two p trendline equation to find the predicted value for $15.00 and $4 Marti and Val want to maximize their profit. They estimate their including travel, to be about $15.50 per art work. Profit = Price* works sold - production cost* works sold . They use this profit funtion to find the profits they earned at eac The vertex of the parabola shows Marti and Val the price with th Use the formula x = -b/(2a) to find the x-coordinate of the vertex What should Marti and Val price their art works at to have the m
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
Type your answer here Use excel to calculate what their maximum profit would be if the coordinate of the parabola you found in step 4 above. (Hint: plug coordinate into the the price & profit trendline equation you fou
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
Art Show Price of Artwork Insert the price & Artisphere $25 56 $30 41 Art at the Lake $17 68 $20 62 Art at the Park $16 68 $20 58 Art & Apples $18 64 t works at art way to price their of art works sold and the number similar to last ata. trendline is most Number of Artworks Sold Old Town Arts Fair Riverwalk Art Festival State Street Art Fair nes 40 50 60 70 80 f(x) =
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
Summer Art Fair $40 19 $50 1 $35 32 71.1375 11.0325 Price of Artwork Profit Insert the price & $25 $532.00 $30 $594.50 $17 $102.00 $20 $279.00 $16 $34.00 $20 $261.00 $18 $160.00 $40 $465.50 $50 $34.50 $35 $624.00 Downtown Arts Night rs or $45. They prices. Use the 45.00. Western Arts & Crafts production cost, ch art fair. he highest profit. x of the parabola. maximum profit? 10 15 2 0 10 20 30 40 $10 $15 $0.00 $100.00 $200.00 $300.00 $400.00 $500.00 $600.00 $700.00
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
ey used the x- g in the x- und)
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
& quantity Scatterplot here − 2.00348965869436 x + 101.194569750617 Number of Artworks Sold
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
& profit Scatterplot here 20 25 30 35 40 45 50 55 $20 $25 $30 $35 $40 $45 $50 $55 f(x) = − 2.0334387528534 x² + 133.6934529759 x − 1582.15610209108 Profit
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
Which trend line is best for Matt' Insert a scatterplot of the data here. Estimated number of cell phones in 1991: 8.751164428756 Estimated number of cell phones in 2001: 171.603531913338 Matt is working on a project to show how technology use had chang He find data that shows how many cell phone subscribers there were He wants to use this data to predict how many cell phones there wo amount to actual current data. Use your trendline equation to estimate, or predict, the number of c the United States in the years 1991 and 2001. What problems do you see with Matt's plan to use this infor predict the number of cell phone users today? 0 2 4 6 8 10 0 20 40 60 80 100 120 f(x) = 6.49862954313331 exp( 0.297583844063355 x ) Subscribers (millions)
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
's data? Input Variable Output Variable Year Subscribers (millions) 0 5.238 3 16.009 4 24.134 5 33.786 6 44.043 7 55.312 8 69.209 9 86.047 10 109.48 606 8 161133.222232615 ged over time. e in the United States in 1990-1999. ould be in the United States today and then compare that Number of Cell Phones in United States 1990-2000 cell phones in rmation to 0 12
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
The model predits to many people because this is way more p
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
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
people then are alive today
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
Which trend line is best fo Insert a scatterplot of the data her Estimated light intensity at 1.25 meters: Estimated light intensity at 2.2 meters: Lisa is helping her daughter Kaitlyn with a science proje They use a sensing device to measure the light intensit Kaitlyn needs to find a trendline for this data. Use your trendline equation to estimate, or predict, th from the light source or 2.2 meters from the light sourc 0.8 1 1.2 1.4 1.6 0 0.05 0.1 0.15 0.2 0.25 0.3 0.35 f(x) = 1.09941033493833 exp( − 1.37976530197479 x ) Intensity (candelas)
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
or Kaitlyn's data? re. Input Variable Output Variable Distance (meters) Intensity (candelas) 1 0.2965 1.1 0.2522 1.2 0.2055 1.3 0.1746 1.4 0.1534 1.5 0.1352 1.6 0.1145 1.7 0.1024 1.8 0.0923 1.9 0.0832 2 0.0734 0.195883453119125 0.0528004574989 ect. ty of a 100-watt light bulb at various distances from the light source. Light Intensity of a 100-watt light bulb as measured from a sensing device at various distances from the light source. he light intensity if the sensing device is 1.25 meters ce. 1.8 2 2.2
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
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
What assumptions does James need to make? That people will buy his couch What are James' input and output variables? Input Variable: Sofa Quality Output Variable: Sale Price James lives in Portland, Oregon and has a microfiber couch he w plans on using the money to buy a new computer that costs $11 has $500 saved to purchase a new computer. James needs to de he will get enough money from the sale of his couch to purchas computer. First, estimate the quality of James's couch using a scale of 1-10 Complete a web search of prices of used couches in Portland, O website like Craigslist to complete the search. Without thinking record your take on the quality of the couch using a scale of 1-1 After judging the quality of the sofa record the price of the sofa gathered data on 15 couches and have filled out the table to the Create a scatterplot of the data. Then determine which type of appropriate for this data. Add the trendline to your scatterplot.
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
Follow this link to the textbook to review steps for creating a trendline in Excel: Prediated Sale Price of James' sofa: I chooce the trend line I did becouse it looked the most like it then the oth http://www.byuimath.com/fdmat108/Lesson9.html#excel_instructions_-_trendli Use your trendline equation to predict the sale price of James' s quality. What sale price should James list in his advertisement? Does it enough money from the sale of the couch to pay for the laptop? He will get $155.51 from his couch, that probably wont be enough money wants. How did you decide which type of trendline to use? How strong your data? Why does the strengh of the trendline matter? Shou the trendline affect James' decision?
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
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
Sofa Quality Sale Price Insert Scatterplo 6 $ 100.00 8 $ 1,000.00 7 $ 350.00 3 $ 100.00 6 $ 225.00 2 $ 50.00 4 $ 80.00 8 $ 500.00 wants to sell. James 150. He currently etermine whether se the new 0, 10 being best. Oregon. Use a about the price, 10, 10 being best. a. Once you've e right. trendline is most . 800 1000 1200 f(x) = 2
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
5 $ 400.00 9 $ 500.00 4 $ 75.00 3 $ 130.00 4 $ 50.00 3 $ 60.00 9 $ 850.00 155.515240195829 her trendlines. ines sofa, based on it appear he will get ? to get the computer he g was the pattern in uld the strengh of 1 2 0 200 400 600 f(x) = 2
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
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
ot here Advertisement: Super soft suede like material. Large / big 3 person sofa 90" width 36" high 36" depth. Sink into this sofa just once, and you'll know how it got its name. Designed with extra-deep seats and three layers of thick padding on the arms and back, it's designed for unparalleled comfort. 22.1592644074003 exp( 0.389748778667699 x ) Sale Price
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
3 4 5 6 7 8 9 10 22.1592644074003 exp( 0.389748778667699 x )
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

Related Documents

Week 1.docx
BUS-FPX3007-Leadership- Application Questionnaire- Assessment 1.docx
Seervant Leaederhsip Model - DGraham.docx
Week 3 Reading Quiz_Karl Schutte.docx
​MSB 571 - PED1-Ethical Dilemma Selection Form.docx
Leader Profile Activity (Class Session 11).docx
Organization and Management Extra Credit.docx
Quiz 2 Managerial Accounting Study Guide Chapters 4 and 5.docx
Case Study 14 Answers Comp and Benefits.docx
Homework Assignment 3 - Utilization and variability_S.docx
Mini Assignment 2.docx
HRM_FPX5090_ThompsonNia_Assessment1-1.docx
Recommended textbooks for you
Text book image
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Text book image
Contemporary Marketing
Marketing
ISBN:9780357033777
Author:Louis E. Boone, David L. Kurtz
Publisher:Cengage Learning
Text book image
Marketing
Marketing
ISBN:9780357033791
Author:Pride, William M
Publisher:South Western Educational Publishing
SEE MORE TEXTBOOKS
Recommended textbooks for you
  • Text book image
    Practical Management Science
    Operations Management
    ISBN:9781337406659
    Author:WINSTON, Wayne L.
    Publisher:Cengage,
    Text book image
    Contemporary Marketing
    Marketing
    ISBN:9780357033777
    Author:Louis E. Boone, David L. Kurtz
    Publisher:Cengage Learning
    Text book image
    Marketing
    Marketing
    ISBN:9780357033791
    Author:Pride, William M
    Publisher:South Western Educational Publishing
Text book image
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Text book image
Contemporary Marketing
Marketing
ISBN:9780357033777
Author:Louis E. Boone, David L. Kurtz
Publisher:Cengage Learning
Text book image
Marketing
Marketing
ISBN:9780357033791
Author:Pride, William M
Publisher:South Western Educational Publishing
SEE MORE TEXTBOOKS