Household Manufacturing has collected the following data on quantity sold (Q), price (P), income (1), and...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Household Manufacturing has collected the following data on quantity sold (Q), price (P), income (1), and advertising (A). Period Quantity, Q Price, P Income, M Advertising, A 1 120 8.0 10 3 2. 165 4.0 22 7 3 120 7.0 20 4 165 3.0 20 8 180 4.0 30 8. 6 90 10.0 19 6 7 150 4.0 18 10.2 8. 190 1.6 25 9.3 9. 160 5.0 30 8. 10 200 2.0 35 9.5 a. Use the multiple regression package such as SPSS or other regression packages to estimate the linear relationship between quantity as the dependent variable and price, income, and advertising as independent variables. Write the linear equation that you find. b. What is the coefficient of determination? Explain what it means? c. Do the signs of the coefficients make economic sense? Which of the coefficients are significant? (alpha = 0.025, df = 6, critical t-statistic = 2.447) d. If Price = 2.0, Income = 35 and Advertising = 9.5, what is the predicted quantity sold? e. Find the price and income elasticities using the information above (d). Interpret the answers. f. Explain how the above model can be used as a forecasting technique. Show how it is done. Household Manufacturing has collected the following data on quantity sold (Q), price (P), income (1), and advertising (A). Period Quantity, Q Price, P Income, M Advertising, A 1 120 8.0 10 3 2. 165 4.0 22 7 3 120 7.0 20 4 165 3.0 20 8 180 4.0 30 8. 6 90 10.0 19 6 7 150 4.0 18 10.2 8. 190 1.6 25 9.3 9. 160 5.0 30 8. 10 200 2.0 35 9.5 a. Use the multiple regression package such as SPSS or other regression packages to estimate the linear relationship between quantity as the dependent variable and price, income, and advertising as independent variables. Write the linear equation that you find. b. What is the coefficient of determination? Explain what it means? c. Do the signs of the coefficients make economic sense? Which of the coefficients are significant? (alpha = 0.025, df = 6, critical t-statistic = 2.447) d. If Price = 2.0, Income = 35 and Advertising = 9.5, what is the predicted quantity sold? e. Find the price and income elasticities using the information above (d). Interpret the answers. f. Explain how the above model can be used as a forecasting technique. Show how it is done.
Expert Answer:
Answer rating: 100% (QA)
The regression results in Excel are below A The estimated linear equation is below Q 20586 1224P 141... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
A research organization has collected the following data on household size and telephone ownership for 200 U.S. households. At the 0.05 level, are the two variables independent? Based on the...
-
A consumer analyst collected the following data on the screen sizes of popular LCD televisions sold recently at a large retailer: a. Does there appear to be a linear relationship between the screen...
-
A sales manager collected the following data on annual sales for new customer accounts and the number of years of experience for a sample of 10 salespersons. / a. Develop a scatter diagram for these...
-
Assume an employee signs a non - disparagement clause. What would be considered breaking this clause? a . ) Telling a company's trade secret to a competing firm for a fee b . ) Using a work computer...
-
You are considering three investments, each with the same expected value and each with two possible payoffs. The investments are sold only in increments of $500. You have $1,000 to invest and so you...
-
What two presentation classification issues are important for the audit of investments?
-
The Busy B Company wants to store data about its employees skills. Each employee may possess one or more specific skills. In addition, several employees may have the same skill. The following facts...
-
Determine the price of a $200,000 bond issue under each of the following independentassumptions: Maturty Interest Paid Stated Rate Effective Rate 10 years annually 2. 10 years emiannually 3. 20 years...
-
Supply the missing data for three service companies shown in the table below: Note: Loss amounts should be indicated by a minus sign. Round your percentage answers to nearest whole percent. Sales Net...
-
Whitestone Company produces two subassemblies, JR-14 and RM-13, used in manufacturing trucks. The company is currently using an absorption costing system that applies overhead based on direct-labor...
-
You must provide the names of the companies operating in Lithuania, their fields of activity and brief information about the products the y produce: 1. Home appliances; 2. Cosmetics; 3. Computer...
-
What is a political theory and what are its uses? (b) Discuss in detail the political theories of Thomas Hobbes and John Locke? What are the similarities and differences in their theories of the...
-
How has CRISPR-Cas9 technology revolutionized functional genomics, and what are some notable applications in biomedical research and therapeutics ?
-
Why should we treat political theory as political philosophy? Why is political theory the same as political philosophy? What makes it different from political philosophy? What makes it trustworthy...
-
An 10-kg block starts sliding with a velocity of 10 m/s down a inclined plane with an angle of inclination of 30 degrees, as shown in the figure below. The highest point of the incline is at a...
-
Ms. Mattingly, a well-to-do farmer, has a legal right to apply pesticides to her fruit trees. One year, she decided to hire a crop-dusting airplane to spread a pesticide on her orchard. An unexpected...
-
How does factors and measurements impact the healthcare delivery? How does clinical performance measures help stakeholders in healthcare?
-
In your readings, there were many examples given for nurturing close family relationships in this ever-evolving technological society we live in Based upon your readings and research describe three...
-
An observer stands at an overpass and, for each motorcycle that passes below, records the value of x = the number of riders on the motorcycle. a. What value would you anticipate for the mode of her...
-
For the multiple regression equation obtained in Exercise 16.11, what is the coefficient of multiple determination and exactly what does it mean? In exercise Ad Colum Discount New Visitors, y Club...
-
Indicate whether each of the following random variables is discrete or continuous. a. The diameter of aluminum rods coming off a production line b. The number of years of schooling employees have...
-
Argue using combinatorics and mathematical induction that, under assumptions (a)- (c) listed at the start of the section, there are \(n\) ! total possible complete matchings.
-
Verify that the matching in Figure 1.52 is maximal by computing the total weight of each possible matching.
-
Find an augmenting path for the matching below, and use it to produce a new matching with more edges. 1+ +6 2 7 +6 3 2. 8 4. 3- 9 .8 5. 4 10 +9 5. 10 Exercise 3 Exercise 4
Study smarter with the SolutionInn App