Homework answers / question archive / Quiz 6 – MOD 2 (pairs) 1

Quiz 6 – MOD 2 (pairs) 1

Sociology

Share With

Quiz 6 – MOD 2 (pairs) 1. The data belowi gives the invoice price and the suggested sale price for 9 sedans. Model Invoice Price MSRP 2021 Dodge Charger SXT $29,501 $29,995 2021 Hyundai Sonata SEL $24,524 $25,800 2021 Kia Stinger GT AWD $39,200 $41,790 2021 Mazda6 Touring $25,565 $27,075 2021 Nissan Altima 2.5 SV $23,673 $25,400 2021 Nissan Maxima Platinum 3.5L $39,405 $42,220 2021 Toyota Avalon Hybrid XLE $33,391 $37,100 2021 Toyota Camry LE $22,848 $24,970 2021 Toyota Prius Prime XLE $28,800 $30,000 Using the data given above, answer the following questions: a. Using Excel, provide the graph and the modeling equation. (5 points) b. What value can you expect with an invoice price of $35,000? (5 points) c. What does the number in part (b) mean? Write at least 1 sentence. (10 points) d. Can this trend continue? Why or why not? Explain your reasoning and provide concrete examples. (10 points) 2. The data belowii lists various stars with their names, Temperatures (Kelvin), and Luminosity. Name Temp (K) Luminosity AE Aurigae 33000 59000 Alpha Centauri A 5790 1.519 Chi Draconis A 6150 1.86 Iota Orionis Aa 32500 68000 Iota Orionis Ab 27000 8630 Meissa 25400 63000 Mintaka Aa2 25600 16000 Mintaka B 18400 3300 Mu Columbae 33000 45700 Phi1 Orionis 30000 28840 Plaskett's Star B 33000 123000 Sigma Orionis Ab 31000 18600 Sol 5772 1 UW Canis Majoris A 33750 310000 Xi Persei 35000 263000 Zeta Ophiuchi 34000 91000 Name _____________________ Course & Section _____________________ Date _____________________ Using the data, answer the following questions: a. Using Excel, provide the graph and the modeling equation. (5 points) b. What would you predict for a temperature of 24075 Kelvin? (5 points) c. What does the number in part (b) mean? Write at least 1 sentence. (10 points) d. Can this trend continue? Why or why not? Explain your reasoning with concrete examples. (10 points) 3. Below is dataiii for year and batting average for 15 Major League players. Last First Year BA Aaron Hank 1964 0.328 Abreu Bobby 1999 0.335 Adair Jerry 1967 0.271 Aikens Willie 1983 0.302 Alfonzo Edgardo 2003 0.259 Allen Dick 1968 0.263 Alomar Roberto 1993 0.326 Alomar Jr. Sandy 1997 0.324 Alou Felipe 1966 0.327 Alou Jesus 1971 0.279 Alou Moises 2003 0.280 Anderson Garret 2003 0.315 Ashburn Richie 1960 0.291 Backman Wally 1985 0.273 Baerga Carlos 1993 0.321 a. Using Excel, create a scatter plot. (5 points) b. Can you create a model? Why or why not? (5 points) c. Are there any conclusions that you can draw from the data? (10 points) 4. You have recently purchased a house and need to purchase an extension ladder. The highest window is 18 feet off the ground. OSHA says that a safe angle for a ladderiv is 75°. What length of ladder do you need? Round your answer to the nearest foot. (10 points) Name _____________________ Course & Section _____________________ Date _____________________ 5. You wish to purchase a sun shade for your back patio. There is 9 feet between the roof-line and the top of your patio door. You need the shade to extend 12 feet from the door to cover the patio. a. What length (house to end of patio) of sun shade do you need to purchase? (5 points) b. If your sun shade needs to be 25 feet wide, how much will it cost if the material is $2.45 per square foot? (5 points) i https://www.consumerreports.org/new-cars/best-new-car-deals/ https://www.astronomytrek.com/list-of-different-star-types/ with temperature and luminosity data courtesy of Wikipedia iii https://regressit.com/data iv https://www.osha.gov/Publications/portable_ladder_qc.html ii