hw problem & answers Question #1 Question #2 Quest Question #3 3. (A) Perform a multiple regression analysis on the above data to see if household income and population can be used to predict future sales. (B) Predict sales for the next three years based on the income and population projections listed below. (fill in the blanks on the first sheet) Average Number of Household Widgets Year Households Income Sold 1980 39.5 34,000 5,500 1981 39.8 34,600 5,600 1982 40.4 41,000 5,900 1983 43.1 38,000 5,800 1984 43.2 39,000 6,100 1985 44.0 42,000 6,900 1986 44.5 44,000 6,300 1987 46.2 49,000 7,300 1988 46.5 46,000 6,700 1989 46.8 51,000 6,900 1990 47.0 48,000 7,200 1991 47.1 47,000 7,100 1992 47.3 50,000 7,100 1993 47.7 51,000 7,400 1994 48.0 53,000 7,600 1995 48.1 54,000 7,900 1996 48.4 55,000 7,300 1997 48.5 53,000 8,000 1998 49.0 57,000 8,500
hw problem & answers Question #1 Question #2 Quest Question #3 3. (A) Perform a multiple regression analysis on the above data to see if household income and population can be used to predict future sales. (B) Predict sales for the next three years based on the income and population projections listed below. (fill in the blanks on the first sheet) Average Number of Household Widgets Year Households Income Sold 1980 39.5 34,000 5,500 1981 39.8 34,600 5,600 1982 40.4 41,000 5,900 1983 43.1 38,000 5,800 1984 43.2 39,000 6,100 1985 44.0 42,000 6,900 1986 44.5 44,000 6,300 1987 46.2 49,000 7,300 1988 46.5 46,000 6,700 1989 46.8 51,000 6,900 1990 47.0 48,000 7,200 1991 47.1 47,000 7,100 1992 47.3 50,000 7,100 1993 47.7 51,000 7,400 1994 48.0 53,000 7,600 1995 48.1 54,000 7,900 1996 48.4 55,000 7,300 1997 48.5 53,000 8,000 1998 49.0 57,000 8,500
Century 21 Accounting Multicolumn Journal
11th Edition
ISBN:9781337679503
Author:Gilbertson
Publisher:Gilbertson
Chapter17: Financial Statement Analysis
Section: Chapter Questions
Problem 1AP
Related questions
Question
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
Recommended textbooks for you
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:
9781337679503
Author:
Gilbertson
Publisher:
Cengage
Essentials of Business Analytics (MindTap Course …
Statistics
ISBN:
9781305627734
Author:
Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:
Cengage Learning
Essentials Of Business Analytics
Statistics
ISBN:
9781285187273
Author:
Camm, Jeff.
Publisher:
Cengage Learning,
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:
9781337679503
Author:
Gilbertson
Publisher:
Cengage
Essentials of Business Analytics (MindTap Course …
Statistics
ISBN:
9781305627734
Author:
Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:
Cengage Learning
Essentials Of Business Analytics
Statistics
ISBN:
9781285187273
Author:
Camm, Jeff.
Publisher:
Cengage Learning,