X | Y | X^2 | Y^2 | XY | |
58 | 70.736 | 3364 | 5003.582 | 4102.688 | |
80 | 77.636 | 6400 | 6027.348 | 6210.88 | |
35 | 62.986 | 1225 | 3967.236 | 2204.51 | |
98 | 83.276 | 9604 | 6934.892 | 8161.048 | |
81 | 77.806 | 6561 | 6053.774 | 6302.286 | |
40 | 64.196 | 1600 | 4121.126 | 2567.84 | |
63 | 71.206 | 3969 | 5070.294 | 4485.978 | |
78 | 76.296 | 6084 | 5821.08 | 5951.088 | |
40 | 64.676 | 1600 | 4182.985 | 2587.04 | |
83 | 78.856 | 6889 | 6218.269 | 6545.048 | |
42 | 64.776 | 1764 | 4195.93 | 2720.592 | |
70 | 73.046 | 4900 | 5335.718 | 5113.22 | |
Total | 768 | 865.492 | 53960 | 62932.23 | 56952.22 |
we have,
where, a = intercept
and b = slope
Thus,
a = (865.492*53960 - 768*56952.22) / (12*53960 - 768^2) = 51.35
b = (12*56952.22 - 768*865.492) / (12*53960 - 768^2) = 0.32
Thus,
a) slope = b1 = 0.32
b) Intercept = b0 = 51.35
- 1 of 11 ID: MST.SLR.REE.03.0030 [2 points] A study is conducted to determine the simple...
A study is conducted to determine the simple linear regression relation (if any) between average temperature over a week and ice-cream sales in a particular city. The following table provides the regression data required to construct the model Average Temperature and Ice-cream Sales Weekly Ice-cream Sales Average Temperature over a Week (oF) 64 35 58 48 73 91 65 52 36 84 37 30 ($'000s) 177.041 118.477 164.065 144.705 194.215 230.063 177.767 152.149 121.353 215.591 123.129 108.847 Calculate the slope...
A study is conducted to determine the simple linear regression relation (if any) between average temperature over a week and ice-cream sales in a particular city. The following table provides the regression data required to construct the model: Sales Average Temperature Weekly Ice-cream Sales over a Week (°F) 54 74 85 37 36 94 52 45 38 98 54 (s'000s) 287.883 181.983 228.343 254.575 141.089 139.097 277.223 177,129 160.095 144.061 285.981 181.233 Calculate the slope (bi) and intercept (bo) of...
An economist conducted a study of the possible association between weekly income and weekly grocery expenditures. The particular interest was whether higher income would result in shoppers spending more on groceries. A random sample of shoppers at a local supermarket was obtained, and a questionnaire was administered asking about the weekly income of the shopper's family and the grocery bill for that week. The gender of the shopper was also obtained. The data below are expenditures and income for 10...
Using simple regression, determine whether test scores are
significantly related to sales performance. Use significance level
of 0.05%. Clearly interpret the slope (beta coefficient) and the
adjusted R squared value you obtained.
Using multiple regression, determine whether test scores and
number of months are significantly related to sales performance.
Use significance level of 0.05%. Clearly interpret the slopes (beta
coefficients) and the adjusted R squared value you obtained.
E ៥ដង А B c D 1 DATA SET FOR SALESFORCE PROBLEM...
correlation and regression
The director of sales at a large ice-cream parlor company want to see if there is a relationship between Ice-cream sales and temperature. They have 15 different parlors from all over the country report on their sales total for a day in the week and what the hi temperature temperature was that day. The data collected is given below. 1. What conclusion can be drawn 2. Predict the amount of money a parlor would make when the...
A study was performed to evaluate a potential relationship between heart rate and exercise minutes per week in a random sample of 11 subjects aged 20 to 29 years. The results were as follows: Exercise (min/week) HR (beats/min) 10 88 20 83 30 78 40 75 50 78 60 75 70 70 80 66 90 63 100 65...
using spss
2. The following table lists total sales of a specific merchandise in six stores during four seasons (Final Q2.sav): Sales (in thousand dollars) Winter Fall Summer Young Adults Young Adults Young AdultsYoung Adults 57 59 69 60 78 79 68 67 68 67 58 64 65 63 61 63 80 54 63 62 76 68 75 79 64 60 72 81 78 78 83 57 60 58 74 81 78 61 63 61 59 84 57 81 63...
The laboratory performed a comparison study of LDL-c values in 40 participants (40 samples are split so are considered matched or pairs) using two different analyzers, the Abbott and the Roche. The Abbott is considered the gold standard method used in many facilities and the Roche is new and of interest due to faster turn-around time and economical factors. The purpose of the comparison study is to determine if there is a significant difference in results by the two methods...
Mergea Center - $ - % Agent 24 You are building a repression equation which relates household weekly expenditure on FOOD to the household's 25 weekly INCOME x=Weekly INCOME (hundreds of dollars) y = Weekly expenditure on FOOD (dollars) 30 From the data for 25 households the following quantities are calculated. 20-y)' 112,28777 Sty-y)- 292,245.84 25 20.776 301.920 Sxy=166,105.00 XX 11.559.28 38 Use the above quantities to answer questions 1.10 391 The estimated regression equation indicates that for each additional...
Time Period t Daily Sales 1 59 2 56 3 92 4 78 5 63 6 75 7 81 8 65 9 99 10 86 11 72 12 89 13 107 14 104 15 93 16 106 17 104 18 124 19 110 20 106 Given the Data Above for the first 20 days Daily Sales of a new restaurant, use a Regression Tool like DATA ANALYSIS in Excel and find each of the following: Slope of Regression Equation =...