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
Get step-by-step solutions from verified subject matter experts
