Cheryl Johnson, the director of marketing for the Thingamajig Company, has collected data on the annual...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Cheryl Johnson, the director of marketing for the Thingamajig Company, has collected data on the annual number of households in the state, the adjusted average annual household income, and Thingamajig's sales of widgets. She would like you to analyze these data for developing a forecast of future widget sales. Year 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 Number of Households 39.5 39.8 40.4 43.1 43.2 44.0 44.5 46.2 46.5 46.8 47.0 47.1 47.3 47.7 48.0 48.1 48.4 48.5 49.0 Average Household Income 34,000 34,600 41,000 38,000 39,000 42,000 44,000 49,000 46,000 51,000 48,000 47,000 50,000 51,000 53,000 54,000 55,000 53,000 57,000 Widgets Sold 5,500 5,600 5,900 5,800 6,100 6,900 6,300 7,300 6,700 6,900 7,200 7,100 7,100 7,400 7,600 7,900 7,300 8,000 8,500 Question #1 1. (A) In sheet Question #1,Perform a regression analysis on the above data to see if the population can be used to predict future sales. (B) Create a graph that shows the historical data, the regression line and 95% confidence interval lines. (C) Predict sales for the next three years based on the population projections listed below. (fill in the blanks below) Estimated Population 52.0 } Year 1999 2000 2001 52.1 52.3 Prediction (D) Is this a good representational model? Why or why not? (Answer): Question #2 2. (A) In sheet Question # 2 perform a regression analysis on the above data to see if household income can be used to predict future sales. (B) Create a graph that shows the historical data, the regression line and 95% confidence interval lines. (C) Predict sales for the next three years based on the income projections listed below. (fill in the blanks below) Estimated Income Year 1999 2000 2001 58,000 62,000 65,000 Prediction (D) Is this a good representational model? Why or why not? (Answer): Question #3 3. (A) In sheet Question # 3 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 below) Estimated Income 58,000 62,000 B B 3 Year 0 1999 2000 2001 65,000 Estimated Population 52.0 52.1 = (C) Is this a good representational model? Why or why not? (Answer): 52.3 Prediction Cheryl Johnson, the director of marketing for the Thingamajig Company, has collected data on the annual number of households in the state, the adjusted average annual household income, and Thingamajig's sales of widgets. She would like you to analyze these data for developing a forecast of future widget sales. Year 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 Number of Households 39.5 39.8 40.4 43.1 43.2 44.0 44.5 46.2 46.5 46.8 47.0 47.1 47.3 47.7 48.0 48.1 48.4 48.5 49.0 Average Household Income 34,000 34,600 41,000 38,000 39,000 42,000 44,000 49,000 46,000 51,000 48,000 47,000 50,000 51,000 53,000 54,000 55,000 53,000 57,000 Widgets Sold 5,500 5,600 5,900 5,800 6,100 6,900 6,300 7,300 6,700 6,900 7,200 7,100 7,100 7,400 7,600 7,900 7,300 8,000 8,500 Question #1 1. (A) In sheet Question #1,Perform a regression analysis on the above data to see if the population can be used to predict future sales. (B) Create a graph that shows the historical data, the regression line and 95% confidence interval lines. (C) Predict sales for the next three years based on the population projections listed below. (fill in the blanks below) Estimated Population 52.0 } Year 1999 2000 2001 52.1 52.3 Prediction (D) Is this a good representational model? Why or why not? (Answer): Question #2 2. (A) In sheet Question # 2 perform a regression analysis on the above data to see if household income can be used to predict future sales. (B) Create a graph that shows the historical data, the regression line and 95% confidence interval lines. (C) Predict sales for the next three years based on the income projections listed below. (fill in the blanks below) Estimated Income Year 1999 2000 2001 58,000 62,000 65,000 Prediction (D) Is this a good representational model? Why or why not? (Answer): Question #3 3. (A) In sheet Question # 3 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 below) Estimated Income 58,000 62,000 B B 3 Year 0 1999 2000 2001 65,000 Estimated Population 52.0 52.1 = (C) Is this a good representational model? Why or why not? (Answer): 52.3 Prediction
Expert Answer:
Related Book For
Posted Date:
Students also viewed these accounting questions
-
In 1987, the base year was changed to [1982 = 100]. Change the base for all the figures in Table. The Consumer Price Index [1967 Year 1950 1951 1952 1953 1954 1955 1956 1957 1958 1959 1960 1961 1962...
-
1. Data: This project makes use of annual data for two risky securities: the S&P 500 Index and Gold. Annual values for each of these securities during the period from 1975-2018 are provided in a...
-
Using a spreadsheet, compute the average return and standard deviation of each of the three asset classes. Compute the annual return of a portfolio consisting of 50% stocks, 40% real estate, and 10%...
-
14. The molecule that has formula C,H, with 2 sp C's, 2 sp C's, and 1 sp C and chiral isomer is H CH3 CH3 (a) (c) H H HC H C=C=C CH 3 C=C=C H CH3 (b) (d) HC=C H HCCC=C CH3 H CHCH3
-
Health World began January with an inventory of 50 crates of vitamins that cost a total of $1,000. During the month, Health World purchased and sold merchandise on account as follows: Purchase 1 . ....
-
Mrs. Emmet has decided to contest a $28,650 tax deficiency. She understands that she can initiate the litigation in district court or the Tax Court. Identify any reasons why she might prefer one...
-
What are some important connections between kinship and transmigration? Kinship relations are an important factor in the migration of people across state borders-a significant dimension of...
-
JustKitchens Inc. provides services to restaurants and hotels. The company supplies paper products, tableware, cookware, restaurant and kitchen equipment, and cleaning supplies. On January 2, 2017,...
-
The HIPAA Privacy Rule provides individuals with certain rights about how their health information is used and disclosed as well as how they can gain access to health records and information about...
-
Kitchen Care Inc. (KCI) is a manufacturer of toaster ovens. To improve control over operations, the president of KCI wants to begin using a flexible budgeting system, rather than use only the current...
-
Assume the following: loan amount: 400,000; loan term, 30 years; annual contract interest rate, 3.5%; monthly payment, $1,769.18; total loan closing costs paid to lender, $7,000; total closing costs...
-
A capacitor using a new dielectric will be tested by connecting it in the circuit shown above with two resistors of resistance R and a power supply of potential difference E. The ammeter A has...
-
It follows from equation (11.34) of Problem 11.6 that Q=-kT log E=U - TS- uN. Show that [-kT log E (T, , V)] is an extensive variable, so that if the intensive variables T and u are kept constant,...
-
6 lb Fig. P13.27 = 13.27 A 6-lb block is attached to a cable and to a spring as shown. The spring constant is k 8 lb/in. and the tension in the cable is 3 lb. If the cable is cut, determine (a) the...
-
Find the moment at point A that keeps the given structure below in equilibrium in its given configuration using Virtual Work principle. 10kN B 2m 2m 2m 30 kN M 2m 2m 2m 30 A
-
The standard form of second order linear nonhomogeneous differential equation with constant coeffi- cients is given by (A) y"(x)+ Py'(x) + Qy(x) = R, where P,Q and R are functions of y or constants...
-
Choose a small creative project to work on. For example, it could be to MAKE a painting, make a short story, make a poem, make some music, perform a dance, or take a photograph. As you're working on...
-
As you rewrite these sentences, replace the cliches and buzzwords with plain language (if you don't recognize any of these terms, you can find definitions online): a. Being a jack-of-all-trades, Dave...
-
Chalet Sports sells hunting and fishing equipment and provides guided hunting and fishing trips. Chalet Sports is owned and operated by Cliff Owen, a well-known sports enthusiast and hunter. Cliffs...
-
Silverado Company is a consulting firm specializing in pollution control. The following adjustments were made for Silverado Company: Identify each of the six pairs of adjustments. For each...
-
Duncan Trophies Inc. uses a job order cost system for determining the cost to manufacture award products (plaques and trophies). Among the company??s products is an engraved plaque that is awarded to...
-
Using the transformation \(w=\sin (z)\), determine the equation for the stream function for flow inside the semi-infinite region \(y \geq 0,-\pi / 2 \leq x \leq \pi / 2\) shown in Figure P9.17. -/2...
-
Show that the stream function for flow in the corner of Figure P9.16 is given by: \[\psi(r, \theta)=A r^{4} \sin (4 \theta)\] Use the transformation \(z=w^{4}\) where \(z=x+i y\) and \(w=\phi+i...
-
Consider the flow formed by placing a source of strength, \(q_{o}\), a distance, \(d\), from an infinitely long wall as shown in Figure P9.18. The velocity potential for this incompressible and...
Study smarter with the SolutionInn App