Business Analytics > Predictive Modelling > Practical: Data 1st part

Example: Following is the data set consisting 40 rows on Sales, advertising, Size of the firm and income. We may use MS Excel to compute multiple linear regression.

No	Advertising	Size	Income	Sales
1	20	1500	40	210
2	25	1600	45	230
3	30	1700	50	260
4	35	1800	55	280
5	40	2000	60	320
6	22	1550	42	220
7	28	1650	48	250
8	33	1750	52	270
9	38	1850	58	300
10	45	2100	65	340
11	18	1400	38	200
12	26	1580	44	235
13	31	1680	49	255
14	36	1780	53	275
15	42	2050	62	325
16	24	1520	43	225
17	29	1620	47	245
18	34	1720	51	265
19	39	1820	57	295
20	44	2080	64	335

 

Prev

Multiple Linear Regression

Next

Practical Data: 2nd Part

Feedback

Submit