CH10SIMPLE LINEAR REGRESSION (cont.(商务统计,英文版)).ppt

BEO1106 - Week 10 BEO1106 - Week 10 Business StatisticsBEO 1106 * * 郴妓壬姑棍喝哑偏皋礼屯敖蕉常潍泰釉滇莫沃朋喝曝鲤棉婿振役骸茨降乾CH10SIMPLE LINEAR REGRESSION (cont.(商务统计,英文版))CH10SIMPLE LINEAR REGRESSION (cont.(商务统计,英文版)) WEEK 10 SIMPLE LINEAR REGRESSION (cont.) TIME-SERIES ANALYSIS Reference: Selvanathan et al. (2004), Chapters 11, 13 副偶后谦责今岗丸懈奴混顶诵裂茁咕划概铂欺测皑毗垒毫屁宋星拔乳璃匆CH10SIMPLE LINEAR REGRESSION (cont.(商务统计,英文版))CH10SIMPLE LINEAR REGRESSION (cont.(商务统计,英文版)) EVALUATING SIMPLE LINEAR REGRESSION There is just one independent variable in the model. The relationship between X and Y can be depicted with a straight line. Ex 1: (Selvanathan 2004 ed. - p.494, ex.11.72 (2000 ed.- p.419, ex.11.61)) The manager of Colonial Furniture has been reviewing weekly advertising expenditures. During the past six months all advertisements for the store have been appeared in the local newspaper. The number of ads per week has varied from one to seven. The store’s sales staff has been tracking the number of customers who enter the store each week. The number of ads and the number of customers per week for the past 26 weeks have been stored in the file Xr11-72. Number of ads per week is the independent variable (X), and the number of customers per week is the dependent variable (Y). The purpose of advertising in the local newspaper is to boost sales, so we expect a positive relationship between X and Y. 娶铅懒提琐辟惜拟畴罐携褥茧咀撵服俏卵缆棍审篱恋鳃嘱宿刑烫块唾赚厄CH10SIMPLE LINEAR REGRESSION (cont.(商务统计,英文版))CH10SIMPLE LINEAR REGRESSION (cont.(商务统计,英文版)) Graph the paired observations of X and Y. This scatter diagram shows that, at least in the sample, there is some rather weak positive linear relationship between the numbers of ads and customers. Determine the sample regression line. We are going to rely on Excel. However, at home, try to reproduce the results manually using the sum of squares: SSx = 86.654, SSy = 463802 and SSxy = 1850.6. 挺敖取哄趴镑宛惊肚融匆冬巍摧容昭逃蹦缚钧甥葱领逃儡琳脑痛吁刨盂歹CH10SIMPLE LINEAR REGRESSION (cont.(商务统计,英文版))CH10SIMPLE LINEAR REGRES