Let X = Price
Y = Sales
X | Y | |
0.33 | 20 | |
0.25 | 14 | |
0.44 | 22 | |
0.4 | 21 | |
0.35 | 16 | |
0.39 | 19 | |
0.29 | 15 | |
MEAN ![]() |
0.35 | 18.1429 |
S.D ![]() |
0.0612 | 2.8997 |
r | 0.8778 |
The Regression Equation of Y on X is
The Regression Equation of X on Y is
The Correlation Coefficeint "r" = 0.8778
The Coefficient of Determination =
= 0.7705
Also we can get
as the Product of two regression coefficients
= 41.5908x0.0185
= 0.7694
Both are Same; no need to get Confusion. While Calculating Continuously withour break we get such difference.
5. A company has recorded data on the weekly sales for its product (y) and the...
uestion (2) (30 Marks A supermarket wishes to assess the effect of shelf display space on the sales of a product. The manager has tried out different shelf lengths for a week each and has recorded the resulting sales Sales (Es) Shelf length (metres) 155 173 85 228 186 148 130 156 178 107 120 110 0.8 1.2 0.5 1.8 1.4 0.9 1.1 1.3 1.6 0.7 0.9 1.0 Answer the following Questions (1) Plot the scatter diagram.(2 Marks) (2) Calculate...
Case: A small convenience store chain is interested in modeling the weekly sales of a store, y, as a function of the weekly traffic flow on the street where the store is located. The table below contains data collected from 24 stores in the chain. Store Weekly Traffic Flow (thousands of cars) Weekly Sales ($ thousands) 1 59.3 6.3 2 60.3 6.6 3 82.1 7.6 4 32.3 3.0 5 98 9.5 6 54.1 5.9 7 54.4 6.1 8 51.3 5.0...
2. Multiple coefficient of determination Aa Aa Macroeconomics is the study of the economy as a whole. A macroeconomic variable is one that measures a characteristic of the whole economy or one of its large-scale sectors. In forecasting the sales of a product, market researchers frequently use macroeconomic variables in addition to marketing mix variables (marketing mix variables include product, price, place [or distribution], and promotion) A market researcher is analyzing an existing multiple regression model that predicts sales for...
2. Multiple coefficient of determination Macroeconomics is the study of the economy as a whole. A macroeconomic variable is one that measures a characteristic of the whole economy or one of its large-scale sectors. In forecasting the sales of a product, market researchers frequently use macroeconomic variables in addition to marketing mix variables (marketing mix variables include product, price, place [or distribution], and promotion). A market researcher is analyzing an existing multiple regression model that predicts sales for different brands...
2. Multiple coefficient of determination Aa Aa E Macroeconomics is the study of the economy as a whole. A macroeconomic variable is one that measures a characteristic of the whole economy or one of its large-scale sectors. In forecasting the sales of a product, market researchers frequently use macroeconomic variables in addition to marketing mix variables (marketing mix variables include product, price, place [or distribution], and promotion) A market researcher is analyzing an existing multiple regression model that predicts sales...
Question 5: The historical data on sales, prices, and selling expenses of a company is given in table: Using the regression tool in EXCEL, answer the following Sales Price Selling questions: Expense 16 2 a. What is the estimated intercept (a) of the regression? 14 4 9 b. What is the estimated regression coefficient of the product's price (B1)? 10 7 c. What is the estimated regression coefficient of Selling Expense (B2)? 8 9 11 5 13 4 14 E...
A sales manager collected the following data on x = years of experience and y = annual sales ($1,000s). The estimated regression equation for these data is ŷ = 80 + 4x. Salesperson Years of Experience Annual Sales ($1,000s) 1 1 80 2 3 97 3 4 97 4 4 102 5 6 103 6 8 101 7 10 119 8 10 118 9 11 127 10 13 136 (a) Compute SST, SSR, and SSE. SST= SSR= SSE= (b) Compute...
Consider the following sample data for the relationship between advertising budget and sales for Product A: Observation 1 2 3 4 5 6 7 8 9 10 Advertising ($) 60,000 70,000 70,000 80,000 80,000 90,000 100,000 100,000 110,000 110,000 Sales ($) 363,000 432,000 417,000 502,000 483,000 537,000 614,000 625,000 653,000 666,000 What is the R2 coefficient of determination value for the relationship between advertising and sales? Please round your answer to the nearest hundredth. Note that the correct answer will...
from part 5-12 plz dont do 1-4
BUNUS Assignment! A Sample Data AnalySIS III Licer Please answer all of the following questions. Make sure you show all your work, providing snapshots from Excel as well as listing all formulas and relevant explanation, as needed. We are interested in exploring the relationship between the income of professors (measured in thousands of dollars) and the number of years they have been employed by the university. We collect the following data from eight...
Q.5: (12 marks) [CLO 1, 2, 3] Khalid has established a large trading company to import mobile phones from Korea and sell in the MENA region. His sales data shows that there is a positive relationship between sales revenue and advertisement expenditure. He wants to forecast for revenues if the advertisement expenses are increased from current year's AED 12 million to AED 15 million. There are number of ways to forecast such as moving average method, and ftting a curve...