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

Hypothesis testing, After analyzing the data the researcher has to test ten...

After analyzing the data the researcher has to test ten hypotheses various tests such as chi square test t test have been developed by statisticians for the purpose. The hypotheses

Hypotheses testing, Celia is a nurse in a geriatric ward.  She noticed that...

Celia is a nurse in a geriatric ward.  She noticed that older persons in her care are having problems sleeping at night.  She decided to introduce non-pharmocologic ways of relaxat

What is the cumulative distribution function, The waiting time for an incom...

The waiting time for an incoming call at the front desk of mathematics Department follows an exponential distribution. During business hours, the average of the waiting times is 10

Time series, importance of time series analysis?

importance of time series analysis?

Index number, Why index numbers serve as economic barometers?

Why index numbers serve as economic barometers?

Determine the probability, Question 1: A mail-order firm has a circular...

Question 1: A mail-order firm has a circular which elicits a 10% response rate. Suppose 20 of the circulars are mailed as a market test in a new geographic area. Assuming that

Determine the price rate-demand , SkyyMarley Airlines has determined that t...

SkyyMarley Airlines has determined that the price elasticity of demand for two customer segments (Coach and Business Class) is -1.35 and -2.50.  Based on their expectations of prof

What is the probability, Suppose the entire cola industry produces only two...

Suppose the entire cola industry produces only two colas viz., Pepsi and Coke.  Given that a person last purchased Pepsi, there is 90% that his next purchase will be Pepsi.  Given

Simple random sampling, This type of sampling is also known as chance sampl...

This type of sampling is also known as chance sampling or probability where each and every item in the population has an equal change of inclusion in the sample and one of the poss

#13, A survey showed that 80% of the 1600 adult respondents believe in glob...

A survey showed that 80% of the 1600 adult respondents believe in global warming. Construct a 95% confidence interval estimate of the proportion of adults believing in global warmi

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