Essentials of Business Analytics (MindTap Course List)
2nd Edition
ISBN: 9781305627734
Author: Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 7, Problem 15P
The U.S. Department of Energy’s Fuel Economy Guide provides fuel efficiency data for cars and trucks. A portion of the data for 311 compact, midsized, and large cars follows. The Class column identifies the size of the car: Compact, Midsize, or Large. The Displacement column shows the engine’s displacement in liters. The FuelType column shows whether the car uses premium (P) or regular (R) fuel, and the HwyMPG column shows the fuel efficiency rating for highway driving in terms of miles per gallon. The complete data set is contained in the tile FuelData:
- a. Develop an estimated regression equation that can be used to predict the fuel efficiency for highway driving given the engine’s displacement. Test for significance using the 0.05 level of significance. How much of the variation in the sample values of HwyMPG does this estimated regression equation explain?
- b. Create a scatter chart with HwyMPG on the y-axis and displacement on the x-axis for which the points representing compact, midsize, and large automobiles are shown in different shapes and/or colors. What does this chart suggest about the relationship between the class of automobile (compact, midsize, and large) and HwyMPG?
- c. Now consider the addition of the dummy variables ClassMidsize and ClassLarge to the simple linear regression model in part (a). The value of ClassMidsize is 1 if the car is a midsize car and 0 otherwise; the value of ClassLarge is 1 if the car is a large car and 0 otherwise. Thus, for a compact car, the value of ClassMidsize and the value of ClassLarge are both 0. Develop the estimated regression equation that can be used to predict the fuel efficiency for highway driving, given the engine’s displacement and the dummy variables ClassMidsize and ClassLarge. How much of the variation in the sample values of HwyMPG is explained by this estimated regression equation?
- d. Use significance level of 0.05 to determine whether the dummy variables added to the model in part (c) are significant.
- e. Consider the addition of the dummy variable FuelPremium, where the value of FuelPremium is 1 if the car uses premium fuel and 0 if the car uses regular fuel. Develop the estimated regression equation that can be used to predict the fuel efficiency for highway driving given the engine’s displacement, the dummy variables ClassMidsize and ClassLarge, and the dummy variable FuelPremium. How much of the variation in the sample values of HwyMPG does this estimated regression equation explain?
- f. For the estimated regression equation developed in part (e), test for the significance of the relationship between each of the independent variables and the dependent variable using the 0.05 level of significance for each test.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Estimate what percentage of the class received a B
Given data: 147, 243, 156, 632, 543, 303, 559
Find the five-number summary.
If New Hampshire's population was 1.4 million in 2018 and there were 1.3 million motor vehicle registrations what is the ratio of people to vehicle in New Hampshire?
Chapter 7 Solutions
Essentials of Business Analytics (MindTap Course List)
Ch. 7 - Bicycling World, a magazine devoted to cycling,...Ch. 7 - In a manufacturing process the assembly line speed...Ch. 7 - Jensen Tire Auto is deciding whether to purchase...Ch. 7 - A sociologist was hired by a large city hospital...Ch. 7 - The regional transit authority for a major...Ch. 7 - A marketing professor at Givens College is...Ch. 7 - The Dow Jones Industrial Average (DJIA) and the...Ch. 7 - The Toyota Camry is one of the best-selling cars...Ch. 7 - Dixie Showtime Movie Theaters, Inc., owns and...Ch. 7 - Prob. 10P
Ch. 7 - The American Association of Individual Investors...Ch. 7 - The National Football League (NFL) records a...Ch. 7 - Johnson Filtration. Inc., provides maintenance...Ch. 7 - A study investigated the relationship between...Ch. 7 - The U.S. Department of Energys Fuel Economy Guide...Ch. 7 - A highway department is studying the relationship...Ch. 7 - A sample containing years to maturity and...Ch. 7 - In 2011, home prices and mortgage rates fell so...Ch. 7 - A recent 10-year study conducted by a research...Ch. 7 - The Scholastic Aptitude Test (or SAT) is a...Ch. 7 - Consider again the example introduced in Section...Ch. 7 - Alumni donations are an important source of...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.Similar questions
- The higher education department of Holmes Institute recorded data on the number of students enrolled in the different study majors for the years 2018 and 2019. The data are stored in file STUDYMAJOR.xls. Use an appropriate graphical technique or chart to compare the number of enrolments in 2018 and 2019 of the different study majors. Display the chart. Use an appropriate graphical technique or chart to display the percentage value of the number of enrolments of the different study major in 2018 and 2019. Display the chart. Study Major 2018 2019 Statistics 1700 2250 Business Law 700 900 Accounting 1300 1450 Economics 750 1000 Finance 1450 1758 Marketing Management 1069 1189 Auditing 360 351arrow_forwardGiven this multiple-line chart, find the total number of chairs and sofas sold during June. (Note: All sales numbers are plotted to the nearest 10 units.) Sales of Sofas and Chairs -Chairs 280 Sofas 260 3 240 * 220 200 180 160 140 April May June Montharrow_forwardFind the SLG Percentage for Mr Hodowith 52 doubles, 31 singles, 2 triples, 61homeruns, and 335 at bats.arrow_forward
- A statistics professor kept attendance records and recorded the number of absent students per class. This data is displayed in the following histogram with the frequency of each number of absent students shown above the bars. How many total classes do these data represent?arrow_forwardA website that reviews recent movies lists 4 five-star films (the highest rating). 15 four-star films, 17 three-star films, 10 two-star films, and 4 one-star films. Make a frequency table for the data set. Include columns for relative frequency and cumulative frequency. Complete the table. (Type integers or decimals rounded to the nearest tenth as needed.) Stars Frequency Relative frequency 5 ☐ Cumulative frequencyarrow_forwardFind the Fan Cost Index for the Atlanta United. Team Ticket Other Drink Soft Drink Hot Dog Parking Hat FCI Atlanta United $28 $5 $2 $2 $25 $25arrow_forward
- Fruit prices and the amounts consumed for 2010 and 2018 are shown. Use 2010 as the base. Fruit Bananas (pound) Grapefruit (each) Apples (pound) Strawberries (basket) Oranges (bag) Fruit Bananas Grapefruit Apples Strawberries Oranges %media:2excel.ext% Click here for the Excel Data File 2010 Price Quantity Price $0.24 100 $0.34 0.28 0.50 0.34 0.68 1.03 2.42 0.91 1.01 Simple index Simple aggregate price index 50 85 8 6 Laspeyres price index 2018 a. Determine the simple price indexes. (Round your answers to 2 decimal places.) Quantity 116 51 85 10 11 b. Determine the simple aggregate price index for the two years. (Round your answer to 2 decimal places.) c. Determine the Laspeyres price index. (Round your answer to 2 decimal places.)arrow_forwardEach year America.EDU ranks the best paying college degrees in America. The following data show the median starting salary, the mid-career salary, and the percentage increase from starting salary to mid-career salary for the 20 college degrees with the highest mid-career salary (America.EDU website, August 29, 2013). Click on the datafile logo to reference the data. Degree Starting Salary Mid-Salary % Aerospace Eng 59,400 108,000 82 Applied Math 56,400 101,000 79 Biomed Eng 54,800 101,000 84 Chemical Eng 64,800 108,000 67 Civil Eng 53,500 93,400 75 Computer Eng 61,200 87,700 43 Computer Sci 56,200 97,700 74 Construction Mgmt 50,400 87,000 73 Economics 48,800 97,800 100 Electrical Eng 60,800 104,000 71 Finance 47,500 91,500 93 Government 41,500 88,300 113 Info Systems 49,300 87,100 77 Mgmt Info Sys 50,900 90,300 77 Mathematics 46,400 88,300 90 Nuclear Eng 63,900 104,000 63 Petroleum Eng 93,000 157,000 69…arrow_forward. The discharge analysis report of Anywhere Health Care Facility shows 1752 discharges (including deaths) for October 2020. Fifty-two deaths were also shown in the report. Find gross death rate.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw HillHolt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGAL
- Mathematics For Machine TechnologyAdvanced MathISBN:9781337798310Author:Peterson, John.Publisher:Cengage Learning,Algebra: Structure And Method, Book 1AlgebraISBN:9780395977224Author:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. ColePublisher:McDougal Littell
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Mathematics For Machine Technology
Advanced Math
ISBN:9781337798310
Author:Peterson, John.
Publisher:Cengage Learning,
Algebra: Structure And Method, Book 1
Algebra
ISBN:9780395977224
Author:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Publisher:McDougal Littell
Hypothesis Testing using Confidence Interval Approach; Author: BUM2413 Applied Statistics UMP;https://www.youtube.com/watch?v=Hq1l3e9pLyY;License: Standard YouTube License, CC-BY
Hypothesis Testing - Difference of Two Means - Student's -Distribution & Normal Distribution; Author: The Organic Chemistry Tutor;https://www.youtube.com/watch?v=UcZwyzwWU7o;License: Standard Youtube License