In order to determine whether or not the number of automobiles sold per day (Y) is related to price (X1 in $1,000), and the number of advertising spots (X2), data were gathered for 7 days. Part of the regression results is shown below. 
a. Determine the least squares regression function relating Y to X1 and X2.
b. If the company charges $20,000 for each car and uses 10 advertising spots, how many cars would you expect them to sell in a day?
c. At = 0.05, test to determine if the fitted equation developed in Part a represents a significant relationship between the independent variables and the dependent variable.d. At 95% confidence, test to see if price is a significant variable.e. At 95% confidence, test to see if the number of advertising spots is a significant variable.f. Determine the multiple coefficient of determination.
Definitions:
Percentage of Sales Approach
A financial forecasting method where various financial statement items are predicted as a percentage of sales.
Retained earnings
Earnings accumulated by a company up to the present moment, subtracting any dividends or payouts made to investors.
Sustainable Growth Rate
The maximum rate at which a company can grow its sales, earnings, and dividends without incurring new debt.
Debt-equity Ratio
An indicator that differentiates the financing portion between debt and equity for company assets.
Q1: A medical journal reported the following frequencies
Q4: The Brock Juice Company has developed
Q9: Consumer's risk is<br>A)the same concept as the
Q10: What is the forecast for July based
Q10: Refer to Exhibit 22-2. The population total
Q47: In an analysis of variance problem if
Q55: The sales records of a company over
Q66: Regression analysis was applied between sales (in
Q72: Refer to Exhibit 14-8. The slope of
Q81: A statistical test conducted to determine whether