Question: Select two continuous variables that you believe are correlated. Copy the variable's data into a new worksheet. Create the linear regression analysis in Excel. On
Select two continuous variables that you believe are correlated.
Copy the variable's data into a new worksheet. Create the linear regression analysis in Excel.
On the worksheet with the analysis provide the requested statistic and indicate what information your analysis is providing:
Correlation coefficient
Coefficient of determination
The y-intercept (regression coefficient alpha)
The slope of the regression line (regression coefficient beta)
Use the equation to demonstrate the relationship between your two variables by using a small and a large value for your independent and noting the impact on your dependent variable.
Create a Scatter Chart which displays the regression line.
Using the guidelines discussed in class, ensure your visualization is designed so that the message is clear and understood quickly, the chart looks balanced and professional, clutter is removed and the linear regression line is identified clearly.
Use the statistical tools we learned in class to summarize the relationship between the variables, comment on the effectiveness of the regression line to forecast the dependent variable and provide other information about the relationship between the two variables.
NEED URGENT HELP WITH THIS ASSIGNEMENT
| ID | First | Last | Full Name | Department | Hire Year | Gross Pay | Taxes | CPP Contribution | EI Contribution | Bonus | Net Pay | Sick Leaves | Performance Score |
| e111-215 | Ann | Jawa | Ann Jawa | IT | 2008 | $92,900 | $12,077 | $4,645 | $1,394 | $3,000 | $77,785 | 8 | 4 |
| e157-517 | Emma | Melendez | Emma Melendez | Faculty | 2010 | $83,000 | $10,790 | $4,150 | $1,245 | $2,000 | $68,815 | 7 | 3 |
| e118-120 | William | Holst | William Holst | Faculty | 2011 | $85,200 | $11,076 | $4,260 | $1,278 | $2,000 | $70,586 | 7 | 5 |
| e157-218 | Dorothy | Lafayette | Dorothy Lafayette | Finance | 2011 | $55,800 | $7,254 | $2,790 | $837 | $2,000 | $46,919 | 4 | 5 |
| e122-314 | Will | Castellano | Will Castellano | Faculty | 2012 | $80,500 | $10,465 | $4,025 | $1,208 | $3,000 | $67,803 | 5 | 4 |
| e130-720 | Terry | Hendricks | Terry Hendricks | Student Services | 2012 | $61,000 | $7,930 | $3,050 | $915 | $1,000 | $50,105 | 7 | 4 |
| e147-616 | Shelley | Baker | Shelley Baker | Accounting | 2013 | $60,000 | $7,800 | $3,000 | $900 | $1,500 | $49,800 | 8 | 2 |
| e129-119 | Scott | Davis | Scott Davis | Faculty | 2013 | $78,000 | $10,140 | $3,900 | $1,170 | $2,000 | $64,790 | 11 | 2 |
| e144-918 | Rose | Albert | Rose Albert | Faculty | 2013 | $86,000 | $11,180 | $4,300 | $1,290 | $2,000 | $71,230 | 3 | 5 |
| e175-615 | Michael | Griffith | Michael Griffith | Faculty | 2013 | $73,600 | $9,568 | $3,680 | $1,104 | $1,000 | $60,248 | 7 | 4 |
| e190-416 | Wyatt | Badilla | Wyatt Badilla | IT | 2013 | $94,000 | $12,220 | $4,700 | $1,410 | $3,500 | $79,170 | 6 | 4 |
| e124-318 | Wesley | Cho | Wesley Cho | Faculty | 2014 | $73,500 | $9,555 | $3,675 | $1,103 | $1,500 | $60,668 | 10 | 5 |
| e140-114 | Isabel | McLaughlin | Isabel McLaughlin | Faculty | 2014 | $82,100 | $10,673 | $4,105 | $1,232 | $1,500 | $67,591 | 10 | 3 |
| e140-617 | Lila | Qureshi | Lila Qureshi | Finance | 2014 | $72,100 | $9,373 | $3,605 | $1,082 | $2,000 | $60,041 | 9 | 5 |
| e132-620 | Stephen | Bodnar | Stephen Bodnar | Human Resources | 2014 | $63,000 | $8,190 | $3,150 | $945 | $2,000 | $52,715 | 3 | 4 |
| e148-819 | Monica | Ray | Monica Ray | Human Resources | 2014 | $102,900 | $13,377 | $5,145 | $1,544 | $2,000 | $84,835 | 5 | 5 |
| e187-620 | Erma | Vargas | Erma Vargas | Marketing | 2014 | $102,400 | $13,312 | $5,120 | $1,536 | $1,500 | $83,932 | 7 | 4 |
| e192-215 | Frederick | Kim | Frederick Kim | Student Services | 2014 | $85,100 | $11,063 | $4,255 | $1,277 | $1,000 | $69,506 | 7 | 4 |
| e194-917 | Frank | Anderson | Frank Anderson | Accounting | 2015 | $81,700 | $10,621 | $4,085 | $1,226 | $2,500 | $68,269 | 7 | 2 |
| e177-219 | Dorothy | Dade | Dorothy Dade | Administration | 2015 | $68,500 | $8,905 | $3,425 | $1,028 | $2,500 | $57,643 | 8 | 4 |
| e134-318 | Jennifer | Tang | Jennifer Tang | Faculty | 2015 | $93,000 | $12,090 | $4,650 | $1,395 | $1,000 | $75,865 | 2 | 5 |
| e150-313 | Stephen | Shuler | Stephen Shuler | Faculty | 2015 | $76,700 | $9,971 | $3,835 | $1,151 | $1,000 | $62,744 | 4 | 4 |
| e150-514 | Russell | Rethman | Russell Rethman | Faculty | 2015 | $71,400 | $9,282 | $3,570 | $1,071 | $3,500 | $60,977 | 10 | 5 |
| e166-118 | Judith | Ratcliff | Judith Ratcliff | Faculty | 2015 | $110,000 | $14,300 | $5,500 | $1,650 | $1,500 | $90,050 | 6 | 3 |
| e169-120 | Julia | Mckenzie | Julia Mckenzie | Faculty | 2015 | $95,000 | $12,350 | $4,750 | $1,425 | $1,000 | $77,475 | 5 | 4 |
| e190-419 | Verlie | Yu | Verlie Yu | Faculty | 2015 | $89,100 | $11,583 | $4,455 | $1,337 | $2,000 | $73,726 | 6 | 3 |
| e145-420 | Anita | Lee | Anita Lee | Human Resources | 2015 | $56,000 | $7,280 | $2,800 | $840 | $2,000 | $47,080 | 4 | 4 |
| e149-216 | Maira | Doe | Maira Doe | IT | 2015 | $86,800 | $11,284 | $4,340 | $1,302 | $2,000 | $71,874 | 10 | 3 |
| e154-213 | Olivia | Garcia | Olivia Garcia | IT | 2015 | $56,700 | $7,371 | $2,835 | $851 | $4,000 | $49,644 | 9 | 5 |
| e120-918 | Jamila | Ganeem | Jamila Ganeem | Marketing | 2015 | $83,200 | $10,816 | $4,160 | $1,248 | $2,000 | $68,976 | 3 | 3 |
| e135-715 | Dayna | Adelman | Dayna Adelman | Marketing | 2015 | $70,000 | $9,100 | $3,500 | $1,050 | $2,500 | $58,850 | 2 | 2 |
| e153-213 | Phyllis | Danek | Phyllis Danek | Marketing | 2015 | $57,800 | $7,514 | $2,890 | $867 | $1,000 | $47,529 | 8 | 2 |
| e157-517 | Rachel | Munoz | Rachel Munoz | Marketing | 2015 | $53,500 | $6,955 | $2,675 | $803 | $1,500 | $44,568 | 0 | 5 |
| e191-518 | Ryan | Johnson | Ryan Johnson | Marketing | 2015 | $86,100 | $11,193 | $4,305 | $1,292 | $1,500 | $70,811 | 5 | 2 |
| e126-620 | Antonio | Verdejo | Antonio Verdejo | Accounting | 2016 | $67,400 | $8,762 | $3,370 | $1,011 | $2,500 | $56,757 | 4 | 3 |
| e156-213 | Deborah | King | Deborah King | Accounting | 2016 | $56,600 | $7,358 | $2,830 | $849 | $1,500 | $47,063 | 9 | 2 |
| e189-216 | Patricia | Anderson | Patricia Anderson | Accounting | 2016 | $96,300 | $12,519 | $4,815 | $1,445 | $4,000 | $81,522 | 9 | 2 |
| e137-317 | Camille | Bustamante | Camille Bustamante | Faculty | 2016 | $100,900 | $13,117 | $5,045 | $1,514 | $1,000 | $82,225 | 6 | 4 |
| e161-118 | Christina | Pannell | Christina Pannell | Faculty | 2016 | $98,000 | $12,740 | $4,900 | $1,470 | $2,500 | $81,390 | 7 | 2 |
| e168-714 | Susan | Stetson | Susan Stetson | Faculty | 2016 | $90,000 | $11,700 | $4,500 | $1,350 | $1,500 | $73,950 | 7 | 2 |
| e150-715 | Matthew | Mansfield | Matthew Mansfield | Marketing | 2016 | $63,200 | $8,216 | $3,160 | $948 | $1,500 | $52,376 | 7 | 3 |
| e188-520 | Carrie | Cabot | Carrie Cabot | Student Services | 2016 | $99,700 | $12,961 | $4,985 | $1,496 | $1,500 | $81,759 | 14 | 3 |
| e136-520 | Priscilla | Faucett | Priscilla Faucett | Accounting | 2017 | $60,000 | $7,800 | $3,000 | $900 | $2,000 | $50,300 | 5 | 4 |
| e177-720 | John | Sullivan | John Sullivan | Faculty | 2017 | $100,600 | $13,078 | $5,030 | $1,509 | $1,000 | $81,983 | 5 | 5 |
| e177-919 | Stephanie | Delany | Stephanie Delany | IT | 2017 | $58,000 | $7,540 | $2,900 | $870 | $1,500 | $48,190 | 7 | 2 |
| e125-818 | Tom | Willoughby | Tom Willoughby | Marketing | 2017 | $70,800 | $9,204 | $3,540 | $1,062 | $2,000 | $58,994 | 3 | 2 |
| e184-815 | Bradley | Tufts | Bradley Tufts | Marketing | 2017 | $112,800 | $14,664 | $5,640 | $1,692 | $500 | $91,304 | 1 | 4 |
| e166-617 | Pearl | Meeker | Pearl Meeker | Faculty | 2018 | $89,000 | $11,570 | $4,450 | $1,335 | $1,500 | $73,145 | 8 | 4 |
| e183-518 | Eugene | Beach | Eugene Beach | Faculty | 2018 | $117,000 | $15,210 | $5,850 | $1,755 | $1,000 | $95,185 | 6 | 2 |
| e168-419 | Herbert | Garcia | Herbert Garcia | Human Resources | 2018 | $65,000 | $8,450 | $3,250 | $975 | $2,500 | $54,825 | 4 | 3 |
| e119-520 | Alice | Howard | Alice Howard | Marketing | 2018 | $84,800 | $11,024 | $4,240 | $1,272 | $1,500 | $69,764 | 4 | 3 |
| e148-219 | Jennifer | Prejean | Jennifer Prejean | Student Services | 2018 | $55,000 | $7,150 | $2,750 | $825 | $500 | $44,775 | 3 | 2 |
| e143-817 | Timothy | Morris | Timothy Morris | Accounting | 2019 | $64,600 | $8,398 | $3,230 | $969 | $2,500 | $54,503 | 6 | 3 |
| e172-214 | Natalie | Quezada | Natalie Quezada | Administration | 2019 | $116,200 | $15,106 | $5,810 | $1,743 | $2,000 | $95,541 | 11 | 3 |
| e145-120 | Wendy | Schell | Wendy Schell | Faculty | 2019 | $75,000 | $9,750 | $3,750 | $1,125 | $2,000 | $62,375 | 9 | 3 |
| e123-217 | Amber | Carmody | Amber Carmody | IT | 2019 | $76,300 | $9,919 | $3,815 | $1,145 | $2,000 | $63,422 | 11 | 2 |
| e176-117 | John | Herndon | John Herndon | IT | 2019 | $72,000 | $9,360 | $3,600 | $1,080 | $2,500 | $60,460 | 10 | 3 |
| e177-620 | Raul | Bowen | Raul Bowen | IT | 2019 | $60,700 | $7,891 | $3,035 | $911 | $4,000 | $52,864 | 6 | 3 |
| e195-613 | Sterling | Noll | Sterling Noll | IT | 2019 | $61,300 | $7,969 | $3,065 | $920 | $3,000 | $52,347 | 4 | 4 |
| e183-318 | Nikia | Johnson | Nikia Johnson | Marketing | 2020 | $65,000 | $8,450 | $3,250 | $975 | $2,000 | $54,325 | 6 | 3 |
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock