Question
I NEED HELP WITH THIS PRACTICE QUESTION ON EXCEL PROGRAM, PLEASE I NEED STEP BY STEP GUIDANCE TO LEARN EXCEL PROGRAM BETTER...THANKS On this worksheet,
I NEED HELP WITH THIS PRACTICE QUESTION ON EXCEL PROGRAM, PLEASE I NEED STEP BY STEP GUIDANCE TO LEARN EXCEL PROGRAM BETTER...THANKS
On this worksheet, make an XY scatter plot linked to the following data:
X | Y |
1.01 | 2.8482 |
1.48 | 4.2772 |
1.8 | 4.788 |
1.81 | 5.3757 |
1.07 | 2.5252 |
1.53 | 3.0906 |
1.46 | 4.3362 |
1.38 | 3.2016 |
1.77 | 4.3542 |
1.88 | 4.8692 |
1.32 | 3.8676 |
1.75 | 3.9375 |
1.94 | 5.7424 |
1.19 | 2.4752 |
1.31 | 26.2 |
1.56 | 4.5708 |
1.16 | 2.842 |
1.22 | 2.44 |
1.72 | 5.1256 |
1.45 | 4.3355 |
1.43 | 4.2471 |
1.19 | 3.5343 |
2 | 5.46 |
1.6 | 3.84 |
1.58 | 3.8552 |
- Add trendline, regression equation and r squared to the plot.
- Add this title. ("Scatterplot of X and Y Data")
- The scatterplot reveals a point outside the point pattern. Copy the data to a new location in the worksheet. You now have 2 sets of data.
- Data that are more than 1.5 IQR below Q1 or more than 1.5 IQR above Q3 are considered outliers and must be investigated.
- It was determined that the outlying point resulted from data entry error. Remove the outlier in the copy of the data.
Make a new scatterplot linked to the cleaned data without the outlier, and add title ("Scatterplot without Outlier,") trendline, and regression equation label.
X | Y |
1.01 | 2.8482 |
1.48 | 4.2772 |
1.8 | 4.788 |
1.81 | 5.3757 |
1.07 | 2.5252 |
1.53 | 3.0906 |
1.46 | 4.3362 |
1.38 | 3.2016 |
1.77 | 4.3542 |
1.88 | 4.8692 |
1.32 | 3.8676 |
1.75 | 3.9375 |
1.94 | 5.7424 |
1.19 | 2.4752 |
1.56 | 4.5708 |
1.16 | 2.842 |
1.22 | 2.44 |
1.72 | 5.1256 |
1.45 | 4.3355 |
1.43 | 4.2471 |
1.19 | 3.5343 |
2 | 5.46 |
1.6 | 3.84 |
1.58 | 3.8552 |
- Compare the regression equations of the two plots. How did removal of the outlier affect the slope and R2? Explain why the slope and R Square change the way they did
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started