Question: GROUP PROJECT #3: REGRESSION ANALYSIS Team Assignment (20 points) Due: Thursday, 7/20/2017 General Instructions: 1. Work with your assigned team and submit a team report

GROUP PROJECT #3: REGRESSION ANALYSIS Team Assignment (20 points) Due: Thursday, 7/20/2017 General Instructions: 1. Work with your assigned team and submit a team report based on the following guidelines. 2. SCENARIO: A cable company is interested in understanding what factors explain customers' satisfaction with their cable television service. A survey is sent to a random selection of customers, and about 100 valid responses are received. 3. Download the Excel data file for the project (BA 376 Grp Proj Data) from Canvas [You'll need to open statgraphics, then open by selecting File->Open->Open Data Source, choose \"External Data File\ID Price Value Variety Kinds Reliability Working Satisfaction Loyalty Package ID Q1 Q2 Q3 Q4 Q5 Q6 Q7 Q8 Q9 (Yes = 1) 1 2 4 6 5 4 3 6 4 1 2 3 3 2 5 4 4 3 2 0 3 5 5 3 2 1 3 3 2 1 4 3 4 5 3 3 5 4 3 1 5 7 6 7 6 3 3 3 2 0 6 5 7 4 7 5 5 6 3 1 7 4 7 2 7 6 5 5 3 0 8 4 1 4 3 7 7 3 2 1 9 4 5 6 6 2 3 1 1 1 10 4 5 4 1 5 5 2 2 1 11 4 6 6 7 6 5 5 3 0 12 3 7 7 5 6 6 5 3 1 13 5 4 3 5 4 5 2 2 1 14 3 1 4 6 5 2 5 3 1 15 4 5 6 6 3 4 3 3 0 16 6 5 3 4 5 5 5 3 1 17 2 5 7 6 5 5 3 2 0 18 4 3 1 1 4 2 4 3 1 19 4 5 7 1 3 3 2 2 1 20 3 3 3 2 6 6 6 4 1 21 2 5 5 4 5 3 5 3 1 22 5 6 5 6 6 4 7 4 0 23 4 5 6 6 6 4 6 4 0 24 7 7 5 3 3 5 6 4 0 25 6 6 2 1 4 5 5 3 0 26 4 6 4 1 2 3 1 1 1 27 2 4 4 1 5 5 2 2 1 28 4 5 2 6 5 4 5 3 0 29 5 4 2 4 5 6 3 2 0 30 4 6 6 3 5 5 7 4 0 31 4 5 6 5 4 3 5 3 1 32 5 4 2 4 4 5 7 4 0 33 5 2 7 4 4 4 1 1 1 34 4 5 4 4 6 4 4 3 0 35 4 3 5 4 3 5 6 4 1 36 6 5 1 3 3 4 2 2 1 37 1 1 5 5 3 3 3 2 0 38 4 5 2 1 3 2 4 3 1 39 4 5 3 6 7 6 7 4 1 40 5 7 7 7 6 5 7 4 0 41 2 1 4 5 3 3 2 2 1 42 5 2 3 2 2 1 1 1 1 43 3 5 6 2 3 4 7 4 1 44 1 2 4 4 5 6 1 1 0 45 7 6 5 4 5 5 6 4 1 46 1 1 2 4 2 4 3 2 0 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 5 6 6 7 6 2 2 2 4 3 5 4 3 2 4 5 7 7 4 5 2 5 5 2 5 3 1 7 1 5 6 6 7 6 2 2 2 4 4 3 5 4 3 2 5 4 7 6 5 5 4 6 6 2 4 3 5 4 6 6 3 1 5 6 6 6 4 5 1 4 7 1 2 5 2 5 1 5 5 4 6 6 2 4 3 5 4 3 5 5 3 5 6 5 7 6 4 7 4 6 6 4 7 5 5 3 5 1 7 5 7 6 4 4 5 7 5 5 7 4 3 6 4 5 2 4 7 4 6 6 4 7 5 5 3 2 3 7 3 5 5 6 5 2 4 6 6 6 7 2 5 2 4 3 2 5 6 5 5 5 5 6 4 6 6 7 7 5 2 2 4 4 5 4 7 6 6 7 3 5 2 4 2 5 2 1 2 5 6 6 3 1 6 4 6 6 6 7 3 1 6 4 5 5 3 5 4 7 3 7 4 4 4 7 6 3 2 3 5 5 2 6 4 6 6 6 7 3 1 6 5 4 3 3 6 5 6 6 3 4 6 7 5 7 4 7 4 3 5 1 5 2 2 6 5 5 2 6 5 4 3 7 5 3 1 4 6 5 4 6 7 5 7 4 7 4 3 5 5 2 3 3 6 3 4 4 5 5 7 5 4 5 6 4 7 4 4 3 6 7 4 2 4 5 5 4 6 4 3 6 7 2 1 7 2 7 5 7 5 4 5 6 5 7 4 4 3 4 2 2 6 5 7 6 6 5 4 3 3 4 4 3 4 3 3 2 4 4 3 2 3 3 3 3 4 3 2 4 4 2 1 5 1 4 2 4 3 3 4 4 3 4 3 3 2 3 2 2 4 3 4 4 4 3 0 1 0 1 0 1 1 1 0 1 0 1 1 0 0 0 1 1 0 1 0 1 0 1 1 1 0 1 0 0 1 0 1 0 1 1 1 0 0 1 1 1 1 1 0 0 0 0 95 96 97 4 2 4 6 4 5 4 4 2 5 1 6 2 5 5 3 5 4 1 2 6 1 2 3 1 1 0 Gender Q10 (Male = 0) 0 1 1 1 1 0 1 0 0 0 1 0 1 0 1 0 0 1 1 1 0 0 1 0 1 0 0 0 0 0 0 1 1 1 0 0 1 1 0 1 1 0 1 1 0 1 Zip Q11 201 219 219 221 201 201 221 221 221 201 221 201 221 201 201 221 221 221 221 221 219 201 221 201 201 201 201 221 219 221 201 201 221 221 221 221 221 221 221 221 201 221 201 219 221 201 Age Q12 1 5 1 3 4 1 4 1 2 4 4 4 3 5 3 5 1 1 5 2 1 2 2 3 2 3 5 2 3 1 3 5 5 1 3 2 1 4 2 5 2 3 5 2 3 4 1 1 0 0 0 0 0 1 1 0 1 1 0 1 0 0 1 1 1 0 1 0 1 1 0 1 1 0 1 0 1 0 0 1 1 0 1 1 0 1 1 1 1 0 0 1 0 1 201 201 219 201 219 201 221 221 221 221 201 201 201 201 221 221 221 201 201 221 201 201 201 219 221 201 219 219 201 221 201 219 201 219 201 201 221 221 201 219 219 221 221 219 201 221 201 201 1 2 5 2 4 1 4 5 2 5 1 3 3 4 5 2 1 2 4 4 3 4 5 2 3 5 2 3 4 1 2 5 2 4 1 4 5 2 4 5 1 5 2 1 2 2 3 2 0 0 0 201 201 221 3 4 3 BA376: Project 3 7/19/2017 Kylene Tyler f. g. The p-vale of price is 0.4029 that is grater than 0.05; thus, the price is not significant at 95% confidence level. The p-value of value is 0.0011 which is less than 0,05; thus, the value is significant at 95% confidence level. The p-vale of variety is 0.9356 that is grater than 0.05; thus, the variety e is not significant at 95% confidence level. The p-vale of kinds is 0.1240 that is grater than 0.05; thus, the kinds is not significant at 95% confidence level.The p-vale of reliability is 0. 0771 that is grater than 0.05; thus, the reliability is not significant at 95% confidence level. The p-vale of working is 0.5037 that is grater than 0.05; thus, the working is not significant at 95% confidence level. h. Satisfaction = 0.697994 - 0.109222*Price + 0.440255*Value - 0.00875487*Variety + 0.157181*Kinds + 0.260162*Reliability + 0.0970974*Working When Price\" and \"Value\" at a 4, , \"Kinds\

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Report The group project will consist of 3-4 team members in the group. Based on the Project work assigned, each group will come out with a Project Report. The group project should tackle Operations...

Attached is a group project assignment instructions. For our assignment we chose Walmart. Attached is the data that we have collected and is needed to be used. What I need is for my part of the...

I am so lost with all of this and the worst part it is due in an hour and a half. I don't know what to do please help. In this course you will have the opportunity to apply the concepts learned to a...

Project Objectives and Group Information a Objectives Businesses operate in dynamic, competitive markets. The costs of activities can vary with changes in laws-e.g. taxes and tariffs, environmental...

ADMN 233 Assignment 4 Assignment 4 Instructions Assignment 4 is worth 20% of your final mark. It should be completed and submitted after you finish Chapter 13 in your textbook. This assignment is...

Group Project 3 Duplicate Deposit Slips Problem 1 (50 points) Currency Cons 0000 Deposit sup Cash Date List of Checks GY To 91500 91510 Tupreme Company's bookkeeper prepared the bar rector May 1,...

Psychology 301: Research Methods I Assignment #6 Research Ethics Page 1 Research Ethics (Part I, Part II, & Part III) Part I: Ch. 4 Study Guide (20 points) Due Date: Monday, June 27, 9:00 a.m. via...

- Construct a group (2-3 members in each). - Use MS project to conduct the given project case. - DUE Date: May, 1st May 2023. - Each group should submit 2 files: 1. The Assignment file (MS Project...

RMIT UNIVERSITY Programming Fundamentals (COSC2531) Assignment 2 Individual assignment (no group work). Submit online via Canvas/Assignments/Assignment 2. Marks are awarded per rubric (please see the...

COMPANY BACKGROUND CM Corporation (CMC) was founded in 2000 by Eric Conner and Phil Martin. The company designs, installs, and services security systems for high-tech companies. The founders, who...

An air-conditioning system operates at a total pressure of 1 atm and consists of a heating section and a humidifier that supplies wet steam (saturated water vapor) at 100oC. Air enters the heating...

How does the sodium-potassium pump in the cell membrane function? What role does this protein play in the cell?

A company is considering a $ 2 5 1 , 0 0 0 investment in machinery with the following net cash flows. The company requires a 1 0 % return on its investments. Year 1 Year 2 Year 3 Year 4 Year 5 Net...

The following are monthly actual and forecast demand levels for May through December for units of a product manufactured by the Deborah Bishop Company in Des Moines: Month May D Actual Demand...