The linear regression, Basic Statistics

Assignment Help:

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.  

 


Related Discussions:- The linear regression

#title.research.methods and statistics, identify a research report publishe...

identify a research report published by reputable agencies and evaluate the following ;the problem that was addressed

Probability distribution, In a mathematics examination the average grade wa...

In a mathematics examination the average grade was 82 and the standard deviation was 5. all students with grade from 88 to 94 received grade of B. if the grade are approximately no

Quartiles and percentiles, Quartiles and Percentiles Percentile can ...

Quartiles and Percentiles Percentile can be explained as : a measure this tells us what is the percent of the total frequency scored at or below the measure. Quartiles

State the model and apply t-test, Studies have linked brain size in infants...

Studies have linked brain size in infants and toddlers to a number of future ailments, including autism. One study looked at the brain sizes of 30 autistic boys and 12 nonautistic

Managerial, Kody Corporation uses a job-order costing system with a plantwi...

Kody Corporation uses a job-order costing system with a plantwide overhead rate based on machine-hours. At the beginning of the year, the company made the following estimates:

What is bond premium and face value of bond, Defining of bond premium in te...

Defining of bond premium in terms of the amount paid over the face value of the bond. And the amount over and above the Face Value of bond which the purchaser pays is called Bond P

Correlation and regression problems, CORRELATION & REGRESSION: 1)  What...

CORRELATION & REGRESSION: 1)  What do you mean by the term correlation? 2)  Point out the differences between coefficient of correlation and regression. 3)  If the correl

Historigrams and histogram, what is the difference between histotigrams and...

what is the difference between histotigrams and histograms?

What is Art collection , What is Art collection A personal perform of art...

What is Art collection A personal perform of art or number of products of unique graphics such as artwork, statues, craftwork or other elements generally determined as a perform

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd