A new online auction site specializes in selling automotive parts for classic cars. The founder of...

A new online auction site specializes in selling automotive parts for classic cars. The founder of the company believes that the price received for a particular item increases with its age (i.e., the age of the car on which the item can be used in years) and with the number of bidders. The Excel multiple regression output is shown below.

*Summary measures*
Multiple R			0.8391
R-Square			0.7041
Adj R-Square			0.6783
StErr of Estimate			148.828
*ANOVA Table*
Source	df	SS	MS	F
Explained	2	1212039.4	606019.7	27.3601
Unexplained	23	509444.9	22149.8

*Regression coefficients*
	Coefficient	Std Err	t-value	p-value
Constant	-1242.99	331.204	-3.7529	0.0010
Age of Item	75.017	10.65	7.0459	0.0000
Number of Bidders	13.973	10.44	1.3380	0.1940

(A) Estimate a multiple regression model for the data.

(B) Which of the variables in this model have regression coefficients that are statistically different from 0 at the 5% significance level?

Given your findings in (B), which variables, if any, would you choose to remove from the model estimated in (A)? Explain your decision.

Solutions

Expert Solution

a) From the coefficient column of the bottom most table, the multiple regression model here could be obtained as:

Price = Constant + Age of Item * Coefficient for Age of Item + Number of Bidders * Coefficient for number of bidders

Price = -1242.99 + 75.017*Age + 13.973*Number of bidders.

b) A parameter is statistically significant if the p-value for the variable is less than the level of significance. Here we are given the level of significance as 0.05.

We see that the constant term and the coefficient for Age of Item, the p-values are less than 0.05 and therefore the 2 variables are significant but for Number of bidders the p-value is greater than 0.05, and therefore the variable is not significant in the model. Therefore the coefficients of Age of Item and constant are significantly different from 0 in the model.

Given our findings in the previous part, we see that the Number of bidders variable is not signficantly different from 0 and therefore we will choose that to remove from the model estimated in (A)

orchestra answered 1 year ago

Next > < Previous

Related Solutions

Consider the online auction site described in Problem 2.31 (Chapter 2, Page no 165). Suppose you...

Consider the online auction site described in Problem 2.31 (Chapter 2, Page no 165). Suppose you want to employ the Publish-Subscribe (also known as Observer) design pattern in your design solution for Problem 2.31. Which classes should implement the Publisher interface? Which classes should implement the Subscriber interface? Explain your answer. (Note: You can introduce new classes or additional methods on the existing classes if you feel it necessary for solution.).

The managers of Poncho Parts, Inc. plan to manufacture engine blocks for classic cars from the...

The managers of Poncho Parts, Inc. plan to manufacture engine blocks for classic cars from the 1960s era. They expect to sell 250 blocks annually for the next 5 years. The necessary foundry and machining equipment will cost a total of $800,000 and belongs in a 30% CCA class for tax purposes. The firm expects to be able to dispose of the manufacturing equipment for $150,000 at the end of the project. Labor and materials costs total $500 per engine...

The managers of Poncho Parts, Inc. plan to manufacture engine blocks for classic cars from the...

The managers of Poncho Parts, Inc. plan to manufacture engine blocks for classic cars from the 1960s era. They expect to sell 250 blocks annually for the next 5 years. The necessary foundry and machining equipment will cost a total of $800,000. This amount will be depreciated on a straight-line basis to zero over the project's life. The firm expects to be able to dispose of the manufacturing equipment for $150,000 at the end of the project. Labor and materials...

Johnson Inc. is a wholesale company selling special parts for the automotive industry. The company uses...

Johnson Inc. is a wholesale company selling special parts for the automotive industry. The company uses weighted-average and a perpetual inventory system. Its inventory records for part SA-123 show the following transactions for the month of May 2020: Date Transaction Units Purchased Unit Cost Units Sold Unit Selling Price May 1 Balance 120 $7.00 May 10 Purchase 500 $7.20 May 15 Sale (100) $12.40 May 21 Sale (150) $12.50 May 23 Purchase 250 $7.30 Required: Assuming Johnson Inc. makes all...

Rocky Corp. and Riley Corp. compete in a local and online consumer automotive parts market. Rocky...

Rocky Corp. and Riley Corp. compete in a local and online consumer automotive parts market. Rocky Corp. has a turnover rate of 8, while Riley Corp. has a turnover rate of 0.5. With just this information, what would be your educated guess as to how each business is doing relative to the other business with regards to (a) return on investment, (b) on-time deliveries, and (c) net income?

An online news site earns revenue by selling subscriptions at price pS and ads at price...

An online news site earns revenue by selling subscriptions at price pS and ads at price pA. For simplicity, assume the site has zero marginal cost. Consumer demand for subscriptions is given by: Qs=1-Ps Demand from advertisers for ad-space depends on the number of subscribers though: Qa=Qs(1-Pa) What price should the firm charge for subscriptions and ads, considered jointly, to maximize profits?

An online education company is considering selling a new online course for $450. They want to...

An online education company is considering selling a new online course for $450. They want to know if their existing customers would be willing to pay that amount, so they randomly sample 20 of their existing customers and ask them what they would be willing to pay. Among the responses, the average is $420, and the SD is $60. A histogram of the samples approximately follows the normal curve. In this problem we will conduct a t-test for the null...

Part 1 Milltown Company specializes in selling used cars. During the month, the dealership sold 31...

Part 1 Milltown Company specializes in selling used cars. During the month, the dealership sold 31 cars at an average price of $15,900 each. The budget for the month was to sell 29 cars at an average price of $16,900. Compute the dealership's sales price variance for the month. $31,000 unfavorable. $10,900 favorable. $31,000 favorable. $33,800 unfavorable. $33,800 favorable. Part 2 A company’s flexible budget for 22,000 units of production showed sales, $105,600; variable costs, $33,000; and fixed costs, $28,000....

A new restaurant situated on a highway in specializes in a chef's salad selling for $7....

A new restaurant situated on a highway in specializes in a chef's salad selling for $7. Daily fixed costs are $1,100, and variable costs are $4 per meal. With a capacity of 550 meals per day, the restaurant serves an average of 500 meals each day. (a.) Determine the current average cost per meal. Round your answer to two decimal places. $______ (b.) A busload of 30 Girl Scouts stops on its way home from the San Bernardino National Forest....

11-14 Highland Automotive wishes to forecast the number of new cars that will be sold next...

11-14 Highland Automotive wishes to forecast the number of new cars that will be sold next week. The following table summarizes the number of new cars sold during each of the past 12 weeks: (PLEASE ANSWER BY USING EXCEL) week number sold 1 22 2 26 3 23 4 27 5 21 6 25 7 28 8 26 9 29 10 29 11 27 12 31 (a) Provide a forecast by using a 3-week weighted moving average technique with weights...

Subjects