The following data are expected to follow a linear relation of the form y = ax+b. Obtain the best linear relation in accordance with a least-squares analysis. Calculate the standard deviation of the data from the predicted straight-line relation :
x| 0.9| 2.3| 3.3| 4.5| 5.7 |6.7
y| 1.1 |1.6| 2.6| 3.2| 4.0| 5.0
Following table shows the calcualtion for regression line:
X | Y | X^2 | Y^2 | XY | |
0.9 | 1.1 | 0.81 | 1.21 | 0.99 | |
2.3 | 1.6 | 5.29 | 2.56 | 3.68 | |
3.3 | 2.6 | 10.89 | 6.76 | 8.58 | |
4.5 | 3.2 | 20.25 | 10.24 | 14.4 | |
5.7 | 4 | 32.49 | 16 | 22.8 | |
6.7 | 5 | 44.89 | 25 | 33.5 | |
Total | 23.4 | 17.5 | 114.62 | 61.77 | 83.95 |
Number of data points : n= 6
Now
Slope of the regression equation is
and intercept of the equation will be
So least sqaure line between the data is
y = 0.6721 x + 0.2955
--------------
Let us find SSE first :
So standard error of estimate will be
The following data are expected to follow a linear relation of the form y = ax+b....
The following data were obtained from a 14ft (drill length) core in shale with discontinuities-bedding surface and high angle joints. Measurements are in inches (in) 5.7 1.3 0.5 1.1 5.3 1.3 3.4 0.3 2.0 4.3 3.2 1.2 2.3 2.9 2,8 3,2 1.2 1.2 3.0 6.2 2.9 6.4 2.6 2.6 3.5 1.0 0.5 1.1 6.8 0.3 0.9 1.7 2.1 5,9 0.9 2.0 0.5 3.1 2.3 4.1 4.2 2.2 2.8 4.3 2.0 4.4 4.5 3.6 0.5 2.1 Calculate the core loss (15...
Using the data file provided with both variables, x and y, answer the following questions using Excel*: 1.Create a scatterplot with the data. Comment on direction, form, strength, outliers and/or other significant findings. 2.Use the linear model to fit a line to the data and determine the equation ỹ = b0 + b1x and Interpret b0and b1. 3.Calculate the coefficient of correlation. Discuss the strength of correlation between the explanatory and response variables. 4.Predict the value for ỹ when you...
Which of the following values cannot be probabilities? 0.03, 0.49, 3/5, 0, 1.35, 1,5/3,2 B. □D, -0.49 E. 3 F. 0 H. 1.35 Use the following cell phone airport data speeds (Mops) from a particular network. Find the percentlie corresponding to the data speed 1.2 Mbps 0.1 0.7 1.4 3.8 10.5 0.1 0.7 1.9 4.1 11.6 0.1 0.8 2.1 4.5 11.8 0.1 0.8 2.1 4.9 11.9 0.3 0.9 2.3 5.4 11.9 0.4 0.9 2.6 5.7 12.4 0.5 0.9 2.7 6.7...
Please use excel to solve. Any help would be greatly appreciated. A B E F G 1 C D Changes in Consumer Price Index, 1960-2006 (Percent) 2 Year-Year Percent Change in Commodities CPI Year-Year Percent Change in Services CPI 3 4 5 6 7 8 Commodities% 0.9 Services% 3.4 0.6 1.7 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37...
The data on the below shows the number of hours a particular drug is in the system of 200 females. Develop a histogram of this data according to the following intervals: Follow the directions. Test the hypothesis that these data are distributed exponentially. Determine the test statistic. Round to two decimal places. (sort the data first) [0, 3) [3, 6) [6, 9) [9, 12) [12, 18) [18, 24) [24, infinity) 34.7 11.8 10 7.8 2.8 20 9.8 20.4 1.2 7.2...
can dba & standard... tics T test With Data Aation and Linear Reg... 184: Linear Regression ad: In Exercise, use Ta... About the correlatio... al Estate Agency Says.. The table below shows the number of hours per day 11 patients suffered from headaches before and after 7 weeks of soft tissue therapy. At 0.01, is there enough evidence to conclude that soft tissue therapy helps to reduce the length of time patients suffer from headaches? Assume the samples are random...
2. List the expected spectral data of 2-ethyl-3-hydroxy-hexanal observed from an IR, a 'H-NMR and mass spectrum. CH3 -CH2 CH C-Hal C-N C-o CEC Intensity CEN Aromatic C=C C=0 220 200 180 160 140 120 60 40 20 0 ppm 100 80 Chemical shift (8) Intensity Bonding C-H Type of Vibration (Stretching unless noted) alkane CH -CH, alkene w-m m w-m bending bending out-of-plane bending alkyne arene Frequency (cm) 2850-3000 1375 and 1450 1450-1475 3000-3100 650-1000 3300 3030 690-900 2720...
solvel only E F G H below is pat data 3. A hospital administrator wished to study the relation between patient satisfaction (Y) and patients age (Xi, in years), severity of illness (X2, an index) and anxiety level (X3, an index). The administrator randomly selected 23 patients and collected the data in pat, where larger values of Y, X2 and X3 are, respectively, associated with more satisfaction, increased severity of illness and more anxiety. The data is saved in Moodle2...
From these data you need to determine the number of individuals that survived to each age, starting with the original 91 at age 0. OBSERVATIONS FROM THE FIELD The following data are collected from the field from an unharvested population of parrots. Listed are longevity data from a cohort of 91 females and fecundity data from a sample of 25 females. The data are only from females because reproductive output in males is difficult to measure. We will assume that...
On Blackboard under "Course Content / Homeworks and Practice Tests" there is an Excel file titled "HW 6 Data" with monthly stock return data to be used for this question: What is Deckers Outdoor Corporation's [DECK] beta? Round to two decimal places. [Hint: Take S&P 500 as a proxy for the market, and use the beta formula from the book. You will need to use two Excel functions: STDEV.S and CORREL] Numeric Answer S&PS00 DECK NKE SBUX -1.5% Ос-19 7.4%...