bway ridership in Washington D. C. during the summer months is believed to be heavily tied to the number of tourists visiting the city. During the past 12 years, the following data have been obtained: Number of Tourists (in millions) 7 2 6 4 14 15 16 12 14 20 15 7 Ridership ( in 100,000) 15 10 13 15 25 27 24 20 27 44 34 17 a) Develop a linear regression model that would predict bus and subway ridership based on the number of tourists. b) Based on your model, predict the bus and subway ridership if there are eight million tourists in the city. c) Find the coefficient of determination and correlation co
Q: Suppose the Sherwin-Williams Company is interested in developing a simple regression model with…
A: Enter Xi and Yi in excel sheet, Go to Data > Data Analysis> Regression Enter the range of X…
Q: 178 5488 (a) Determine the linear regression model that will best predict the EPA fuel efficiency…
A:
Q: Develop an estimated multiple linear regression model that could be used to predict the alumni…
A: SUMMARY OUTPUT Regression Statistics Multiple R…
Q: An article gave a scatter plot along with the least squares line of x = rainfall volume (m) and y =…
A: Disclaimer: Since you have posted a question with multiple subparts, we will solve first 3 subparts…
Q: Carpet City wants to develop a means to forecast its carpet sales. The store manager believes that…
A: a) Let X be the the monthly construction permits and Y be the monthly carpet sales. Since, Y is…
Q: Tensen Tire & Auto IS in the process of deciding whether machine. Managers feel that maintenance…
A: Since you have posted a question with multiple sub-parts, we will solve first three sub- parts for…
Q: 1. there are two sets of data on the number of customers (in hundreds) and sales (in thousands in…
A:
Q: It is believed that the annual repair cost for the sporty automobile Jeep is related to its age. A…
A: Given that X(Car age) Y (Repair Cost) 2 72 3 99 1…
Q: The following table gives information on the amount of sugar (in grams) and the calorie count in one…
A: Given that, the predictive regression equation is y^=91.636+4.730x where, y is calories and x is…
Q: The Tile Shop owner wants to find out how education of his new hires interacts with sales. He is…
A: From the given tables;There are 7 observations.The process of fitting functions of data is knownas…
Q: 5. а) The data showing the time required for a merchandiser to stock a grocery store shelf with a…
A: Data represents the time required for a merchandiser to stock a grocery store shelf with a soft…
Q: The academic advisor wants to predict the typical starting salary of a graduate at a top business…
A: Probabilistic model of interest is linear regression model. Model is Y= β0+β1*X Where Y represents…
Q: Is there any multicollinearity problem in the above multiple regression model? How do you know?…
A: The independent variables are Age, Pressure and Smoker. The dependent variable is Risk stroke. This…
Q: An article gave a scatter plot along with the least squares line of x = rainfall volume (m³) and y =…
A: Given An article with scatter plot and table of data is given.Given multiple choice questions.…
Q: Suppose the Sherwin-Williams Company is interested in developing a simple regression model with…
A: Given that to complete the blank places of the table, so i XiXi YiYi XiXiYiYi Xi2Xi2 Yi2Yi2 1…
Q: Demand for oil changes at Garcia's Garage has been as follows: Month Number of Oil Changes January…
A: Let the name of months be denoted by numbers like January is denoted by 1, February by 2 and so on.…
Q: An engineering student wants to study the impact of temperature and humidity on yield. The following…
A: Since you have posted a question with multiple sub-parts, we will solve first three subparts for…
Q: A research was conducted by a company to analyze the influence of year experience to annual sales.…
A: Since you have posted a question with multiple sub-parts, we will solve first three sub-parts for…
Q: In an attempt to assess the effect of the student's score in the admission test to their academic…
A: The provided information is Sore in admission test x Grade y xy x2 52 80 4160 2704 61 78…
Q: Doctors are interested in the relationship between the dosage of a medicine and the time required…
A: Given information: Sample size of patients n=10 The following table summarizes the given data:…
Q: A corporation administers an aptitude test to all new sales representatives. Management is…
A:
Q: A corporation administers an aptitude test to all new sales representatives. Management is…
A: We have given that, The data set of test scores(X and weekly scores (Y) below, X :- 55, 60, 85,…
Q: The table below shows the average temperature in New York City (NYC), measured in degrees Fahrenheit…
A: Concept: We have given the temperature with respect to the months That is for each month the degree…
Q: An article gave a scatter plot along with the least squares line of x = rainfall volume (m3) and y =…
A:
Q: A liquor wholesaler is interested in assessing the effect of the price of a premium scotch whiskey…
A:
Q: An article in Wood Science and Technology, "Creep in Chipboard, Part 3: Initial Assessment of the…
A:
Q: The basal metabolic rate (kcal/day) of large anteaters is believed to be subject to a power law…
A:
Q: An article in Wood Science and Technology, "Creep in Chipboard, Part 3: Initial Assessment of the…
A: Given that Using excel regression
Q: 00 00 30 40 50 60 samp_reg$Age 00 8 20 30 40 50 60 samp_reg$Age resid(test) samp_reg$In_Income -0.5…
A: The conditions for the validity of a regression analysis are that the the error are normally…
Q: The following data describes weekly gross revenue (), television advertising expenditures (), and…
A:
Q: An auto manufacturing company wanted to investigate how the price of one of its car models…
A:
Q: An article in Wood Science and Technology ("Creep in Chipboard, Part 3: Initial Assessment of the…
A:
Q: 2. A Corporation administers an aptitude test to all new sales representatives. Management is…
A: a. Step-by-step procedure to obtain the regression using the Excel: Enter the data for Weekly…
Q: after Decrease in Utilization of Hormone Replacement Therapy." The authors of the paper used a…
A:
Q: 2. An article in the Tappi Journal (March, 1986) presented data on green liquor Na2S concentration…
A: From the above data A)
Q: Suppose the Sherwin-Williams Company is interested in developing a simple regression model with…
A: For the given data the regression output, as obtained in excel, is as follows Coefficients…
Q: Hormone replacement therapy (HRT) is thought to increase the risk of breast cancer. The accompanying…
A: Solution
Q: An article in Wood Science and Technology, "Creep in Chipboard, Part 3: Initial Assessment of the…
A: num X Y XY X2 Y2 1 54 14.473 889.542 2916 271.3597 2 54 18.693 1009.422 2916 349.4282…
Q: An engineering student wants to study the impact of temperature and humidity on yield. The following…
A: (a) Use EXCEL to obtain the value correlation coefficient r: EXCEL procedure: Go to EXCEL Go…
Q: A market study found that the sales for a firm were related to advertising expenditure, as follows:…
A: Regression Equation = ŷ = bX + a where b is the slope of regression, a is the intercept
Q: An article in Wood Science and Technology, "Creep in Chipboard, Part 3: Initial Assessment of the…
A: We should find the least square estimate of the intercept and slope.
Q: An engineering student wants to study the impact of temperature and humidity on yield. The following…
A: solution
Q: #1) Use these data to develop an estimated regression equation that can be used to predict annual…
A: 1) The regression analysis is conducted using EXCEL. The software procedure is given below: Enter…
Q: A corporation owns several companies. The strategic planner for the corporation believes dollars…
A: Step-by-step procedure to find the regression equation using Excel: In Excel sheet, enter Sales in…
Q: Capacity and price data for a collection of USB flash drives is displayed in the table below.…
A:
Q: 2. A Corporation administers an aptitude test to all new sales representatives. Management is…
A: a. Consider the independent variable, x be test score and dependent variable, y be the weekly sales.…
Q: Develop an estimated multiple linear regression model that could be used to predict the alumni…
A: SUMMARY OUTPUT Regression Statistics Multiple R…
Q: An engineering student wants to study the impact of temperature and humidity on yield. The following…
A: a) given data X Y X*Y X*X X*Y 112 40 4480 12544 1600 118 45 5310 13924 2025…
Q: Develop a regression equation which may be used to predict final examination scores from the…
A: here independent variable = x = mid term score dependent variable = y = final examination score…
Bus and subway ridership in Washington D. C. during the summer months is believed to be heavily tied to the
number of tourists visiting the city. During the past 12 years, the following data have been obtained:
Number of Tourists (in millions) | 7 | 2 | 6 | 4 | 14 | 15 | 16 | 12 | 14 | 20 | 15 | 7 |
Ridership ( in 100,000) | 15 | 10 | 13 | 15 | 25 | 27 | 24 | 20 | 27 | 44 | 34 | 17 |
a) Develop a linear regression model that would predict bus and subway ridership based on the number of tourists.
b) Based on your model, predict the bus and subway ridership if there are eight million tourists in the city.
c) Find the coefficient of determination and
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 3 images
- A mail-order business selling personal computer supplies, software and hardware maintains a centralized warehouse. Management is currently examining the process of distribution from the warehouse and wants to study the factors that affect the warehouse distribution costs. Data collected over 24 random months contain the warehouse’s distribution cost (in thousands of Rands), the sales (in thousands of Rands) and the number of orders received. A multiple linear regression model was fitted to the data by using Stat1.2. Use the output to answer the questions that follow by typing only the letter of the correct option in the answer boxes. Variablesy: Warehouse Distribution Costx1: Salesx2: Number of Orders Model Fitting StatisticsR2 = 0.8504Adj R2: ? Regression Coefficients Beta Parameter Standard b Parameter Standard Estimates…A sample of 20 automobiles was taken, and the miles per gallon (MPG), horsepower, and total weight were recorded. Develop a linear regression model to predict MPG, using horsepower as the only independent variable. Develop another model with weight as the independent variable. Which of these two models is better? Explain. MPG HORSEPOWER WEIGHT 44 67 1,844 44 50 1,998 40 62 1,752 37 69 1,980 37 66 1,797 34 63 2,199 35 90 2,404 32 99 2,611 30 63 3,236 28 91 2,606 26 94 2,580 26 88 2,507 25 124 2,922 22 97 2,434 20 114 3,248 21 102 2,812 18 114 3,382 18 142 3,197 16 153 4,380 16 139 4,036Seven North American Green Frogs (Rana clamitans) had their jumping distance recorded (in mm) multiple times in a laboratory. The mean jumping distance for these frogs along with their length (measured from snout to vent in miMillimeters) are presented in the table below. Length of Frog 52 68 37 65 77 81 59 Mean Jumping Distance 546 673 415 659 793 814 563 (a) Determine the linear regression model that will best predit the mean jumping distance of a North American Green Frog based on the frog's length. (b) How well does the linear regression model fit this sample data? (c) Use the linear regression model to predict the mean jumping distance of a North American Green Frog that is 48 mm in length. No excel, please.
- A statistics consulting center at a major university analyzed data on normal woodchucks for the university's veterinary school. The variables of interest were body weight in grams and heart weight in grams. It was desired to develop a linear regression equation in order to determine if there is a significant linear relationship between heart weight and total body weight. Use this information to answer the questions. Determine the test statistic. Body Weight Heart Weight4050 11.12435 10.13135 15.85740 10.92555 10.73665 11.42035 13.44260 13.92990 11.54935 15.83690 10.12880 12.82760 10.62160 15.42360 14.82040 13.62055 12.92650 15.62665 13.8The following table displays the EPA fuel efficiency estimates (in miles per gallon) and the curbweight (in pounds) for a random sample of current year model vehicles.MPG 23 18 28 19 25 17 18 14Weight 3184 3598 2734 4082 2623 4685 4178 5488(a) Determine the linear regression model that will best predict the EPA fuel efficiency estimates(MPG) of a vehicle based on its curb weight.(b) How well does the linear regression model fit this sample data?(c) For a vehicle that weighs 4000 pounds, predict its EPA fuel efficiency estimate.Carpet City wants to develop a means to forecast its carpet sales. The store manager believes that the store’s sales are directly related to the number of new housing starts in town. The manager has gathered data from county records on monthly house construction permits and from store records on monthly sales. These data are as follows: Monthly Carpet Monthly Construction Sales (1,000 yd.) Permits 5 21 10 35 4 10 3 12 8 16 2 9 12 41 11 15 9 18 14 26 a. Develop a linear regression model for these data and forecast carpet sales if 30 construction permits for new homes are filed. b. Determine the strength of the causal relationship between monthly sales and new home construction by using correlation.
- The monthly premium quoted by an insurance company for a critical illness policy was collected from a sample of 6 adult male smokers at different age. The data for the sample are shown: Age 28 25 50 39 47 31 Premium ($) 75 40 175 125 250 105 Using Age to predict premium, the Linear Regression equation is given by: ŷ =6.556X−112 and r2=0.813y^=6.556X−112 and r2=0.813 a. Identify the independent and Dependent variables. Dependent: Age Premium Independent: Age Premium b. Determine the slope. Slope = Slope = Round to 3 decimal places c. Determine |r||r| . |r|=|r|= Round to 3 decimal places d. Interpret rr : and e. Determine critical r value at 5% significance level and determine if there is a significant linear correlation exists. |r| critical=|r| critical= Round to 3 decimal places Linear Correlation:Linear Correlation: Significant Not Significant f. Predict the monthly premium for a 40 years old adult male smoker.…The total stopping distance (in feet) was measured for a midsize four-door sedan driving in dry conditions at various speeds. The resulting data are presented in the table below. Speed (in mph) 10 20 30 40 50 60 70 80 Total Stopping Distance 27 61 104 168 235 297 386 473 (a) Determine the linear regression model that will best predict the total stopping distance for a midsize four-door sedan driving dry conditions based on the speed of the vehicle. (b) How well does the linear regression model fit this sampe data? (c) Predict the total stopping distance for a midsize four-door sedan driving at a speed of 65 mph in dry conditions. Please no excel. I like seeing the work done so I can understand what I am doing.Scores made by students in a statistics class in the midterm and final examination aregiven below: Student Mid-term Final 1 98 90 2 66 74 3 100 98 4 96 88 5 88 80 6 45 62 7 76 78 8 60 74 9 74 86 10 82 80 Develop a regression equation which may be used to predict final examination scoresfrom the mid-term score.
- It is believed that the annual repair cost for the sporty automobile Jeep is related to its age. A sample of 11 automobiles revealed the results in the table at the right. Car age (xi) 2 3 1 7 5 8 1 2 6 9 4 Repair cost (yi) in £ 72 99 65 138 67 140 83 101 170 121 114 Define the terms regression and correlation analysis From the simple linear model , determine parameters and , with an interpretation of your linear model What would be the cost of repairing car that has been in use for 13 yearsThe owner of Showtime Movie Theaters, Inc. would like to predict weekly gross revenue as a function of advertising expenditures. Historical data for a sample of eight weeks follow. Weekly GrossRevenue($1000s) TelevisonAdvertising($1000s) NewspaperAdvertising($1000s) 96 5.0 1.5 90 2.0 2.0 95 4.0 1.5 92 2.5 2.5 95 3.0 3.3 94 3.5 2.3 94 2.5 4.2 94 3.0 2.5 Part A: Develop an estimated regression equation with the amount of television advertising as the independent variable. Part B: Develop an estimated regression equation with both television advertising and news paper advertising as independent variables. Part C: Is the estimated regression rquation coefficient for television advertising expenditures the same in part (a) and in part (b) ? Interpret the coefficient in each case. Part D : Predict Weekly gross revenue for a week $3500 is spent on television advertising and $1800 is spent on newspaper advertising? Please hurryThe owner of Showtime Movie Theaters, Inc., would like to predictweekly gross revenue as a function of advertising expenditures.Historical data for a sample of eight weeks follow. Weekly GrossRevenue($1000s) Television Advertising($1000s) Newspaper Advertising($1000s) 9690959295949494 5.02.04.02.53.03.52.53.0 1.52.01.52.53.32.34.22 .5 a. Develop an estimated regression equation with the amount oftelevision advertising as the independent variable.b. Develop an estimated regression equation with both televisionadvertising and newspaper advertising as the independent variables.c. Is the estimated regression equation coefficient for televisionadvertising expenditures the same in part (a) and in part (b)?Interpret the coefficient in each case.d. Predict weekly gross revenue for a week when $3500 is spent ontelevision advertising and $1800 is spent on newspaper advertising.