Question

In: Statistics and Probability

explain how a scatter diagram can be used to identify the type of regression to use

explain how a scatter diagram can be used to identify the type of regression to use

Solutions

Expert Solution

Scatter diagram is the easiest way to find the type of regression and also we can able to bring regression equation and R-squared values on the chart itself.

Say for example :

X and Y data set in excel to create a regression equation.

Bring X and Y data in to excel sheet. Select both XY data and go to insert tab. Choose scatter plot diagram and populate the chart on the excel sheet. select any data point with in the chart and right click and add trend line. In the format trend line option choose linear,Exponential, Log,Polynomial, Power and moving average regression and also select display an equation on chart option and R-squared options


Related Solutions

Develop a scatter diagram for these data. Develop the estimated regression equation.
Given the following: X: 1    2    3 4    5 Y: 3    7    5    11    14 Develop a scatter diagram for these data. Develop the estimated regression equation. Use the estimated regression equation to predict the value of Y when X = 4
A data set is given a) (a) Draw a scatter diagram. Comment on the type of...
A data set is given a) (a) Draw a scatter diagram. Comment on the type of relation that appears to exist between x and y. ​(b) Given that x overbarxequals=3.83333.8333​, s Subscript xsxequals=2.40142.4014​, y overbaryequals=3.98333.9833​, s Subscript ysyequals=1.74521.7452​, and requals=negative 0.9457−0.9457​, determine the​ least-squares regression line. ​(c) Graph the​ least-squares regression line on the scatter diagram drawn in part​ (a). x 0 2 4 5 6 6 y 6.0 5.8 4.7 3.0 2.1 2.3
With the aid of a simple generic diagram, identify and explain how the type(s) of chemical...
With the aid of a simple generic diagram, identify and explain how the type(s) of chemical bonding stabilizes a secondary structure that is present in crystal structure of Yeast Hexokinase PII with the correct amino acid sequence
A data set is given below. ​(a) Draw a scatter diagram. Comment on the type of...
A data set is given below. ​(a) Draw a scatter diagram. Comment on the type of relation that appears to exist between x and y. ​(b) Given that x̅ = 3.8333​, Sx = 2.4014 ​, ȳ equals = 3.7333 3.​, Sy = 1.8381​, and r = -0.9545 ​, determine the​ least-squares regression line. (c) Graph the​ least-squares regression line on the scatter diagram drawn in part x   y 0   5.9 2   5.7 4   4.3 5   2.8 6   1.7 6   2...
A data set is given below. ​(a) Draw a scatter diagram. Comment on the type of...
A data set is given below. ​(a) Draw a scatter diagram. Comment on the type of relation that appears to exist between x and y. ​(b) Given that x̅ = 3.6667, sx = 2.0656​, ŷ = 4.2000​, sy = 1.4805, and r = −0.9287​, determine the​ least-squares regression line. ​(c) Graph the​ least-squares regression line on the scatter diagram drawn in part​ (a). x   y 1   5.2 2   5.8 3   5.4 4   3.8 6   2.4 6   2.6 ​(a) Choose the...
Explain with suitable diagram how n-type semiconductor can be obtained from intrinsic silicon
Explain with suitable diagram how n-type semiconductor can be obtained from intrinsic silicon
4. (a) (i) Explain with neat diagram how rod gaps can be used for measurement of...
4. (a) (i) Explain with neat diagram how rod gaps can be used for measurement of high voltages. Compare its performance with a sphere gap. (ii) Explain with neat diagram the principle of operation of an Electrostatic Voltmeter. Discuss its advantages and limitations for high voltage measurements. Or (b) A Rogowski coil is required to measure impulse current of 8 kA having rate of change of current of 1010 A/sec. The voltmeter is connected across the integrating circuit which reads...
how can regression analysis be used to determine causality?
how can regression analysis be used to determine causality?
How can CMMI be used to identify and reconcile process clash? Please explain.
How can CMMI be used to identify and reconcile process clash? Please explain.
How can I explain multivariate regression?
How can I explain multivariate regression?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT