0% found this document useful (0 votes)
27 views17 pages

Raghav Excel

The document presents data on automobile sales, per capita income, and fuel prices in India from 2009 to 2024. It highlights trends in automobile sales, which have generally increased, alongside rising per capita income and fluctuating fuel prices. Correlation analyses indicate a strong relationship between automobile sales and per capita income, as well as a moderate correlation with fuel prices.

Uploaded by

Chakshu Jain
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
0% found this document useful (0 votes)
27 views17 pages

Raghav Excel

The document presents data on automobile sales, per capita income, and fuel prices in India from 2009 to 2024. It highlights trends in automobile sales, which have generally increased, alongside rising per capita income and fluctuating fuel prices. Correlation analyses indicate a strong relationship between automobile sales and per capita income, as well as a moderate correlation with fuel prices.

Uploaded by

Chakshu Jain
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/ 17

YEAR AUTOMOBILE SALES ( IN MILLIONS )

2009-2010 13.69 30
2010-2011 15.51
2011-2012 17.32 25
2012-2013 17.83
2013-2014 18.41
20
2014-2015 19.74
2015-2016 20.53
15
2016-2017 21.82
2017-2018 25
2018-2019 26.28 10
2019-2020 21.55
2020-2021 18.62 5
2021-2022 17.52
2022-2023 21.2 0
2023-2024 23.85 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16

source: society of Indian Automobile


manufactureres
AUTOMOBILE SALES ( IN
MILLIONS )
Column C

6 7 8 9 10 11 12 13 14 15 16
YEAR PER CAPITA INCOME (Rs in thousand)
2009-2010 33.901
2010-2011 36.202 PER CAP
2011-2012 63.462
120
2012-2013 65.538
2013-2014 68.572 100
2014-2015 72.805 80
2015-2016 77.659
2016-2017 86.003 60
2017-2018 87.58 40
2018-2019 92.133
20
2019-2020 94.42
2020-2021 86.034 0
2021-2022 94.054 10 11 12 13 14 15
-20 -20 -20 -20 -20 -20 -
2022-2023 99.404 09 10 11 12 13 14 15
2023-2024 106.744 20 20 20 20 20 20 20

Source: Niti Aayog


PER CAPITA INCOME (Rs in thousand)
120

100

80

60 PER CAPITA INCOME (Rs in


thousand)
40

20

0
10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
-20 -20 -20 -20 -20 -20 -20 -20 -20 -20 -20 -20 -20 -20 -20
09 10 11 12 13 14 15 16 17 18 19 20 21 22 23
20 20 20 20 20 20 20 20 20 20 20 20 20 20 20
YEAR FUEL PRICES / LITRE (PETROL )
2009-2010 52
2010-2011 63.77
2011-2012 68.57 FUEL
2012-2013 72.26
2013-2014 72.43
2014-2015 60.5
2015-2016 64.38
2016-2017 69.99
2017-2018 78.52
2018-2019 73.83
2019-2020 80.43
2020-2021 95.41
2021-2022 95.14
2022-2023 98.34
2023-2024 100.38

Source: ‘Petroleum Planning and Analysis Cell’ of the


Government of India.
FUEL PRICES / LITRE (PETROL )

2009-2010
2010-2011
2011-2012
2012-2013
2013-2014
2014-2015
2015-2016
2016-2017
2017-2018
2018-2019
2019-2020
2020-2021
2021-2022
2022-2023
2023-2024
2009-2010
2010-2011
2011-2012
2012-2013
2013-2014
2014-2015
2015-2016
2016-2017
2017-2018
2018-2019
2019-2020
2020-2021
2021-2022
2022-2023
2023-2024
YEAR AUTOMOBILE SALES ( IN MILLIONS ) FUEL PRICES / LITRE (PETROL )
2009-2010 13.69 52
2010-2011 15.51 63.77
2011-2012 17.32 68.57
2012-2013 17.83 72.26
2013-2014 18.41 72.43
2014-2015 19.74 60.5
2015-2016 20.53 64.38
2016-2017 21.82 69.99
2017-2018 25 78.52
2018-2019 26.28 73.83
2019-2020 21.55 80.43
2020-2021 18.62 95.41
2021-2022 17.52 95.14
2022-2023 21.2 98.34
2023-2024 23.85 100.38
correlation automobile sale and fuel prices

AUTOMOBILE SALES ( IN MILLIONS )


AUTOMOBILE SALES ( IN MILLIONS ) 1
FUEL PRICES / LITRE (PETROL ) 0.387288235318352
uel prices

FUEL PRICES / LITRE (PETROL )

1
YEAR AUTOMOBILE SALES ( IN MILLIONS ) PER CAPITA INCOME (Rs in thousand)
2009-2010 13.69 33.901
2010-2011 15.51 36.202
2011-2012 17.32 63.462
2012-2013 17.83 65.538
2013-2014 18.41 68.572
2014-2015 19.74 72.805
2015-2016 20.53 77.659
2016-2017 21.82 86.003
2017-2018 25 87.58
2018-2019 26.28 92.133
2019-2020 21.55 94.42
2020-2021 18.62 86.034
2021-2022 17.52 94.054
2022-2023 21.2 99.404
2023-2024 23.85 106.744
Correlation automobile sales and consumer income

AUTOMOBILE SALES ( IN MILLIONS )


AUTOMOBILE SALES ( IN MILLIONS ) 1
PER CAPITA INCOME (Rs in thousand) 0.778106612243943
onsumer income

PER CAPITA INCOME (Rs in thousand)

1
YEAR AUTOMOBILE SALES ( IN MILLIONS ) PER CAPITA INCOME (Rs in thousand)
2009-2010 13.69 33.901
2010-2011 15.51 36.202
2011-2012 17.32 63.462
2012-2013 17.83 65.538
2013-2014 18.41 68.572
2014-2015 19.74 72.805
2015-2016 20.53 77.659
2016-2017 21.82 86.003
2017-2018 25 87.58
2018-2019 26.28 92.133
2019-2020 21.55 94.42
2020-2021 18.62 86.034
2021-2022 17.52 94.054
2022-2023 21.2 99.404
2023-2024 23.85 106.744
FUEL PRICES / LITRE (PETROL ) SUMMARY OUTPUT
52
63.77 Regression Statistics
68.57 Multiple R 0.860815052
72.26 R Square 0.74100255375
72.43 Adjusted R Square 0.69783631271
60.5 Standard Error 1.91058733504
64.38 Observations 15
69.99
78.52 ANOVA
73.83 df
80.43 Regression 2
95.41 Residual 12
95.14 Total 14
98.34
100.38 Coefficients
Intercept 14.8634374646
PER CAPITA INCOME (Rs in thousand) 0.20319478767
FUEL PRICES / LITRE (PETROL ) -0.14023659615
SS MS F Significance F
125.32544575537 62.6627228777 17.166251587 0.000301837289
43.804127577963 3.65034396483
169.12957333333

Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0%
2.6980591431936 5.50893686007 0.000134317 8.984871594947 20.7420033342 8.98487159495
0.0388304235942 5.23287589632 0.0002102227 0.118590562659 0.28779901268 0.11859056266
0.055958294261 -2.50609133101 0.0276051362 -0.262159245468 -0.01831394682 -0.26215924547
Upper 95.0%
20.7420033342
0.28779901268
-0.01831394682

You might also like