Question: can you help me develop a linear regression model to forecast revenue. Use all the provided variables. I need to know how to set it

can you help me develop a linear regression model to forecast revenue. Use all the provided variables.

I need to know how to set it up in excel too.

Month Sales_quantity Average_cost employees Revenue
Jan-18 12729 1257.763541 30024676 16010072.1
Feb-18 11636 1358.507 30024676 15807587.4
Mar-18 15922 1384.697024 30024676 22047146
Apr-18 15227 1235.606705 30024676 18814583.3
May-18 8620 1626.621765 30024676 14021479.6
Jun-18 13160 1275.374508 30024676 16783928.5
Jul-18 17254 1110.576805 30024676 19161892.2
Aug-18 8642 1759.42887 30024676 15204984.3
Sep-18 16144 1276.259909 30024676 20603940
Oct-18 18135 1157.588904 30024676 20992874.8
Nov-18 10841 1383.024597 30024676 14993369.7
Dec-18 22113 1256.808558 30024676 27791807.6
Jan-19 15365 1861.476505 27828571 28601586.5
Feb-19 13153 1700.530226 27828571 22367074.1
Mar-19 18339 1621.604699 27828571 29738608.6
Apr-19 13909 2038.321083 27828571 28351007.9
May-19 8553 1784.707557 27828571 15264603.7
Jun-19 15101 1614.837301 27828571 24385658.1
Jul-19 15695 1878.720425 27828571 29486517.1
Aug-19 8314 1836.675157 27828571 15270117.3
Sep-19 17764 2034.509545 27828571 36141027.6
Oct-19 18969 1471.61915 27828571 27915143.7
Nov-19 13433 1583.566541 27828571 21272049.3
Dec-19 27029 1554.410444 27828571 42014159.9
Jan-20 16889 2132.001934 27406473 36007380.7
Feb-20 15864 1916.085185 27406473 30396775.4
Mar-20 22786 2092.43091 27406473 47678130.7
Apr-20 17910 1508.317405 27406473 27013964.7
May-20 10777 2315.008323 27406473 24948844.7
Jun-20 18799 1654.414891 27406473 31101345.5
Jul-20 17899 1891.101303 27406473 33848822.2
Aug-20 9649 1705.323552 27406473 16454667
Sep-20 20159 1570.02295 27406473 31650092.7
Oct-20 19519 1617.511431 27406473 31572205.6
Nov-20 15360 1461.35228 27406473 22446371
Dec-20 30833 1458.376602 27406473 44966125.8
Jan-21 19812 2224.284315 28197847 44067520.9
Feb-21 18424 1955.074205 28197847 36020287.2
Mar-21 29004 1620.3279 28197847 46995990.4
Apr-21 22033 1612.875581 28197847 35536487.7
May-21 14959 1985.400039 28197847 29699599.2
Jun-21 23067 1441.932865 28197847 33261065.4
Jul-21 18397 1947.411801 28197847 35826534.9
Aug-21 12045 1931.810312 28197847 23268655.2
Sep-21 23358 1516.546359 28197847 35423489.9
Oct-21 22644 1759.033991 28197847 39831565.7
Nov-21 19765 1669.574764 28197847 32999145.2
Dec-21 33207 1422.044394 28197847 47221828.2
Jan-22 24096 1513.112554 29878525 36459960.1
Feb-22 21624 1690.089653 29878525 36546498.7
Mar-22 33379 1623.736682 29878525 54198706.7
Apr-22 22265 1470.648534 29878525 32743989.6
May-22 16967 1917.348827 29878525 32531657.5
Jun-22 24958 1911.599553 29878525 47709701.6
Jul-22 21917 2098.46884 29878525 45992141.6
Aug-22 14431 2559.328184 29878525 36933665
Sep-22 23253 2086.881698 29878525 48526260.1
Oct-22 26603 1659.978806 29878525 44160416.2
Nov-22 21987 1654.384704 29878525 36374956.5
Dec-22 38069 1543.420464 29878525 58756473.7
Jan-23 27184 2070.64085 29044998 56288300.9
Feb-23 23509 1711.057181 29044998 40225243.3
Mar-23 32569 1535.882748 29044998 50022165.2
Apr-23 26615 1965.83479 29044998 52320692.9

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!