Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The following table contains a set of randomly generated values for X and Y, using Excel functions Y = 5*rand() and X = 2*rand(). Y
The following table contains a set of randomly generated values for X and Y, using Excel functions
Y = 5*rand() and X = 2*rand().
Y | X | Y | X |
3.708925 | 1.17608 | 4.063363 | 1.37409 |
3.221825 | 0.29897 | 1.721939 | 0.201986 |
1.79957 | 0.173299 | 4.690062 | 1.259708 |
1.225065 | 0.297664 | 2.703896 | 1.433091 |
2.310131 | 0.764708 | 0.686019 | 0.197642 |
1.207962 | 0.462974 | 4.281592 | 0.846724 |
0.472542 | 0.189189 | 0.542242 | 0.416 |
2.675828 | 0.136321 | 1.122469 | 1.306645 |
3.095326 | 1.205884 | 2.63972 | 0.214665 |
0.079925 | 0.758546 | 2.613773 | 1.873197 |
(a) Show a scatter plot of these data and discuss whether there is a linear equation that might describe the relationship between X and Y.
(b) Use Excel to develop a regression model and show the results.
(c) Use the above functions (i.e., Y = 5*rand() and X = 2*rand()) to generate 10 more data points and run a regression again. Show your results.
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