Scribd
Upload
321 views2 pages

Sample Data For Regression

This is the sample data for regression analysis and results are found accordingly with help of excel

Uploaded by

AravindVenkatraman
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
321 views2 pages

Sample Data For Regression

This is the sample data for regression analysis and results are found accordingly with help of excel

Uploaded by

AravindVenkatraman
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 2

Demand estimation using linear regression

Y X1 X2 X3
City Number of weekly riders Price per week Population of city Monthly income of riders
1 192,000 $15 1,800,000 $5,800
2 190,400 $15 1,790,000 $6,200
3 191,200 $15 1,780,000 $6,400
4 177,600 $25 1,778,000 $6,500
5 176,800 $25 1,750,000 $6,550
6 178,400 $25 1,740,000 $6,580
7 180,800 $25 1,725,000 $8,200
8 175,200 $30 1,725,000 $8,600
9 174,400 $30 1,720,000 $8,800
10 173,920 $30 1,705,000 $9,200
11 172,800 $30 1,710,000 $9,630
12 163,200 $40 1,700,000 $10,570
13 161,600 $40 1,695,000 $11,330
14 161,600 $40 1,695,000 $11,600
15 160,800 $40 1,690,000 $11,800
16 159,200 $40 1,630,000 $11,830
17 148,800 $65 1,640,000 $12,650
18 115,696 $102 1,635,000 $13,000
19 147,200 $75 1,630,000 $13,224
20 150,400 $75 1,620,000 $13,766
21 152,000 $75 1,615,000 $14,010
22 136,000 $80 1,605,000 $14,468
23 126,240 $86 1,590,000 $15,000
24 123,888 $98 1,595,000 $15,200
25 126,080 $87 1,590,000 $15,600
26 151,680 $77 1,600,000 $16,000
27 152,800 $63 1,610,000 $16,200
average 160,026 $49.93

To generate the linear regression do the following:


1. Click on Data, then "Data Analysis," and select Regression.
2. In the Input Y Range, select B5:B31
3. In the Input X Range, select C5:F31
4. Under Output Options, choose "New Worksheet Ply" option, then click OK.
X4
Average parking rates per month
$50
$50
$60
$60
$60
$70
$75
$75
$75
$80
$80
$80
$85
$100
$105
$105
$105
$110
$125
$130
$150
$155
$165
$175
$175
$190
$200

You might also like