PROBLEM 1: Analyze the following data using LINEAR TREND ANALYSIS. How many cars will be sold...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
PROBLEM 1: Analyze the following data using LINEAR TREND ANALYSIS. How many cars will be sold in time period 13? + TIME PERIOD NUMBER OF CARS SOLD 1 70 2 80 3 66 4 74 5 64 6 76 7 72 8 83 9 82 10 76 11 84 12 80 PROBLEM 2: As you can see below, a sample of 20 cars was taken, and the miles per gallon (MPG), horsepower, and total weight were recorded. NOTE: You will get negative independent variables (horsepower & weight) and that is OK. A. Develop a simple regression model to predict the dependent variable, MPG (Y), using horsepower (X1) as the independent variable. Predict the dependent variable, MPG (Y), if horsepower (X1) is forecasted to be 117. B. Develop a simple regression model to predict the dependent variable, MPG (Y), using weight (X2) as the independent variable. Predict the dependent variable, MPG (Y), if weight (X2) is forecasted to be 3426. C. Using R, which of the 2 causal forecasting models, A or B, is better? D. Develop a multiple regression model to predict the dependent variable, MPG (Y), using horsepower (X1) and weight (X2) as the 2 independent variables. E. Using R, how does the multiple regression model compare with each of the 2 simple regression models? F. Using the multiple regression model, predict the dependent variable, MPG (Y), if horsepower (X1) is forecasted to be 117 and weight (X2) is forecasted to be 3426. MPG (Y) HORSEPOWER (X1) WEIGHT (X2) 44 67 1844 44 50 1998 40 62 1752 37 69 1980 37 66 1797 34 63 2199 35 90 2404 32 99 2611 30 63 3236 28 91 2606 26 94 2580 26 88 2507 25 124 2922 22 97 2434 20 114 3248 21 102 2812 18 114 3382 18 142 3197 16 153 4380 16 139 4036 PROBLEM 1: Analyze the following data using LINEAR TREND ANALYSIS. How many cars will be sold in time period 13? + TIME PERIOD NUMBER OF CARS SOLD 1 70 2 80 3 66 4 74 5 64 6 76 7 72 8 83 9 82 10 76 11 84 12 80 PROBLEM 2: As you can see below, a sample of 20 cars was taken, and the miles per gallon (MPG), horsepower, and total weight were recorded. NOTE: You will get negative independent variables (horsepower & weight) and that is OK. A. Develop a simple regression model to predict the dependent variable, MPG (Y), using horsepower (X1) as the independent variable. Predict the dependent variable, MPG (Y), if horsepower (X1) is forecasted to be 117. B. Develop a simple regression model to predict the dependent variable, MPG (Y), using weight (X2) as the independent variable. Predict the dependent variable, MPG (Y), if weight (X2) is forecasted to be 3426. C. Using R, which of the 2 causal forecasting models, A or B, is better? D. Develop a multiple regression model to predict the dependent variable, MPG (Y), using horsepower (X1) and weight (X2) as the 2 independent variables. E. Using R, how does the multiple regression model compare with each of the 2 simple regression models? F. Using the multiple regression model, predict the dependent variable, MPG (Y), if horsepower (X1) is forecasted to be 117 and weight (X2) is forecasted to be 3426. MPG (Y) HORSEPOWER (X1) WEIGHT (X2) 44 67 1844 44 50 1998 40 62 1752 37 69 1980 37 66 1797 34 63 2199 35 90 2404 32 99 2611 30 63 3236 28 91 2606 26 94 2580 26 88 2507 25 124 2922 22 97 2434 20 114 3248 21 102 2812 18 114 3382 18 142 3197 16 153 4380 16 139 4036
Expert Answer:
Posted Date:
Students also viewed these accounting questions
-
B-2) A firm has sales of Rs. 10 lacs and fixed cost of Rs. 1.5 lacs. Contribution margin is 30%. It has 10% debt of Rs. 8 lacs. Find out Operating leverage, Financial leverage and Combined leverage....
-
Image transcription text Module 5 Discussion A' Instructions: This discussion will be completed in two parts, and will give you an opportunity to reect upon this week's content and to interact with...
-
7) The second financial statement to prepare is the statement of retained eamings. To determine the ending balance of retained earnings you need to start with the opening balance as reported in the...
-
(a) Find the Maclaurin series for the function f(x)= ln(1+x) and hence that for In(1+x) (b) By keeping the first four terms in the Maclaurin series for In(1+x) integrate the function In(1+x) from x =...
-
Use the results of Exercises 14.20 and 14.21 and the fact that E(BË) = β and var(BË) = Ï2/ Sxx to show that Y0 (AË + BËx0) is a random variable having a normal...
-
Explain how the two methods of cash distribution work, and describe their impact on shareholders. Does everyone always receive cash? If not are some stockholders left out?
-
GL Interiors, Inc., a privately-held enterprise, has a subcontract to produce overhead storage bins for a Boeing airplane. Although GL was a low bidder, Boeing was reluctant to award the business to...
-
The amount of denim used daily by the Southwest Apparel Company in its manufacturing process to make jeans is normally distributed with an average of 4000 yards of denim and a standard deviation of...
-
The following table contains financial information for Trumpter Inc. before closing entries: Cash Supplies Prepaid Rent $13,100 6,000 3,800 Salaries Expense 5,000 Equipment 65,900 Service Revenue...
-
A company buys a policy to insure its revenue in the event of major snowstorms that shut down business. The policy pays nothing for the first such snowstorm of the year and $11000 for each one...
-
create a literature review on 'how do you meet the learning needs of students with learning challenges" Identify a target audience for your literature review. Conduct a focused literature search of...
-
What are the unique challenges and opportunities associated with banking in emerging markets, and how do global banks adapt to these environments?
-
For the graph shown below, find all values of x for which f(x) is not differentiable. -6 -5 -2 -1 y 6 + 3 2 O w -5 2 3 4 6 X
-
Explain the significance of Anti-Money Laundering (AML) and Know Your Customer (KYC) regulations in the banking sector. How do banks implement these regulations in practice?
-
Summarize this 2 topics in Rural Sociology below: a) Intersection b) water www.aljazeera.com/news/2016/6/8/canadas-first-nations-face-systemic-water-crisis...
-
You are considering investing in a mutual fund. The fund is expected to earn a return of 13 percent in the next year. If its annual return is normally distributed with a standard deviation of 17...
-
Per Bag Direct materials: 25 pounds of CWhiz-2000 @ $0.08/lb. = $ 2.00 Direct labor: 0.05 hour @ $32.00/hr. = $ 1.60 The company manufactured 100,000 bags of Cheese-Be-Good in December and used...
-
"Only normal daily entries are made to manufacturing overhead." Do you agree? Explain.
-
What is meant by the index of conservatism? How is it calculated in principle? How can it be used to assess the impact of specific accounting principles? i
-
Phil Rammers is confused about the source documents used in assigning materials and labor costs. Identify the documents and give the entry for each document.
Study smarter with the SolutionInn App