The linear regression, Basic Statistics

Print out your results and bring them with you to the midterm as there will be additional questions on the midterm related to this analysis.  You must hand in your take-home by the beginning of the test.  Late take-homes will not be accepted.   You make work in groups of up to 4 people.  If there is evidence of collaboration beyond that, either in that your group is larger than 4, or that you gave answers to other teams, you will get a 0 on the entire test and be reported to the judiciary committee for cheating.  You will not be graded any differently whether you work individually or in a group, no matter what the group size is (as long as  no more than 4.  Only one take-home per team should be turned in   (If you  have team members from both sections, turn in take-home at 8:10. )

Paxcelli owns a local store that sells leather furniture, and she needs to be able to predict what sales are likely to be.  She has 33 months of past sales data.  She's also gone to the Bureau of Labor Statistics website to look up the state unemployment rate.  (Hint: Download this from the website to avoid entering data by hand!)

2058_table sales.png

Use MS Excel.  You may use either regression technique that was demoed in class, but you will be expected to be familiar with how to interpret the solutions for BOTH at the time of the midterm.

Part A   Perform the appropriate linear trend analysis in Excel

Part B    Perform the appropriate associative forecast in Excel

For both part A and B

* Circle the correct values for  a (intercept), b (slope), and R2.

* Provide an  Excel graphic that displays both the underlying data and the linear regression.  If the graphics are too small, badly distorted or hard to see, you don't get credit.

The formatting points (2 full points!) goes to you if you have done all of the following correctly:

 * List all team members in alphabetic order, A to Z, by last name, at the top right of the 1st  page.

 * Provide at most 2 pages- ONE for part A, ONE for part B  (cover sheets are wasteful!)

 * If handling in more than 1 page, fasten them with a stapler.  


Posted Date: 2/22/2013 5:23:07 AM | Location : United States

Related Discussions:- The linear regression, Assignment Help, Ask Question on The linear regression, Get Answer, Expert's Help, The linear regression Discussions

Write discussion on The linear regression
Your posts are moderated
Related Questions
IFRS: IFRS (International Financial Reporting Standards) is a set of accounting standards that were developed as global standard. The IFRS was developed by IASB (International Acc

1. What type of correlation coefficient would you use to examine the relationship between the following variables? Explain why you have selected the correlation coefficients. A.

Suppose that permanent income, YP (t) is calculated as the average of disposable income (YD t ) over the past 5 years, that is: YP (t) = 0.2(YD t + YD t-1 + YD t-2 + YD t-3

Consider the sample data for plants A, B, C & D of the above company, which are tabulated in table 1. Test whether the four means are equal at the 5% level of significance. Perform

state the advantage of expansion of solid

Problem 1 . Let X 0 ;X 1 ;X 2 . . . be a Markov chain with state space f1; 2g and transition probabilities given as follows: p 11 = 0:3; p 12 = 0:7; p 21 = 0:5; p 22 = 0:5:

CASE STUDY 1 3 MARKS An audit of the accounting records of Loch Ness Ltd. for the year ending 30 June 2012 discovered that the ending inventory balance

In reguards to the airlines indusry, provide a minimum of 300 words for each statement. plus atleast 3 academic resources. 1. hypothesis the basic short-run and long-run behavio

Is there a relationship between mediation activity and cooperation between two nations in conflict? A data set was assembled across 15 time periods. Both variables were measured on