Descriptive analysis on the dataset.

write description on each section bellow.

Assume a Hypothesis following the regression analysis,

Analysis

Measures of Central Tendency:Mean, median and mode must becalculatedat least once each in your excel file.o At leasttwomeasures of central tendency must beusedfor a purpose andexplainedin report.

Measures of Spread:At leastfourmeasures of spread (standard deviation, variance, kurtosis, z-score, percentiles) must becalculatedin your excel file andusedfor a purpose with anexplanation in your report.

Pivot Table Analysis:At least one pivot table analysis is explained properly with numbers and charts to prove hypothesis

Linear Regression, Correlation coefficient r:Least-squares method must be used at leastonceto find a linear regression equation. At leastoneline of best fit must be used on a scatter plot andvisually classified:Explain your answers

Variables:As variables are used/manipulated throughout your report, you mustdescribethem as discrete, continuous or categorical andidentifywhich variables are independent or dependent.o Variables should also belabeledon each graph correctly.

Segment	Country	Product	Discount Band	Units Sold	Manufacturing Price	Sale Price	Gross Sales	Sales	COGS	Profit	Year
Small Business	Canada	Amarilla	Low	1916	$260.00	$300.00	$574,800.00	$563,304.00	$479,000.00	$84,304.00	2014
Government	Canada	Amarilla	Low	1778	$260.00	$350.00	$622,300.00	$597,408.00	$462,280.00	$135,128.00	2013
Government	Canada	Amarilla	Medium	552	$260.00	$350.00	$193,200.00	$183,540.00	$143,520.00	$40,020.00	2014
Government	Canada	Amarilla	Medium	1228	$260.00	$350.00	$429,800.00	$408,310.00	$319,280.00	$89,030.00	2013
Government	Canada	Amarilla	Medium	1135	$260.00	$7.00	$7,945.00	$7,388.85	$5,675.00	$1,713.85	2014
Enterprise	Canada	Amarilla	Medium	1645	$260.00	$125.00	$205,625.00	$191,231.25	$197,400.00	-$6,168.75	2014
Government	Canada	Amarilla	Medium	1118	$260.00	$20.00	$22,360.00	$20,794.80	$11,180.00	$9,614.80	2014
Government	Canada	Amarilla	Medium	708	$260.00	$20.00	$14,160.00	$13,027.20	$7,080.00	$5,947.20	2014
Government	Canada	Amarilla	Medium	1269	$260.00	$350.00	$444,150.00	$404,176.50	$329,940.00	$74,236.50	2014
Midmarket	Canada	Amarilla	Medium	1630.5	$260.00	$15.00	$24,457.50	$22,256.33	$16,305.00	$5,951.33	2014
Government	Canada	Amarilla	High	2240	$260.00	$350.00	$784,000.00	$705,600.00	$582,400.00	$123,200.00	2014
Channel Partners	Canada	Amarilla	High	3520.5	$260.00	$12.00	$42,246.00	$38,021.40	$10,561.50	$27,459.90	2014
Government	Canada	Amarilla	High	707	$260.00	$350.00	$247,450.00	$222,705.00	$183,820.00	$38,885.00	2014
Government	Canada	Amarilla	High	2734	$260.00	$7.00	$19,138.00	$16,841.44	$13,670.00	$3,171.44	2014
Channel Partners	Canada	Amarilla	High	2761	$260.00	$12.00	$33,132.00	$29,156.16	$8,283.00	$20,873.16	2013
Enterprise	Canada	Amarilla	High	1659	$260.00	$125.00	$207,375.00	$180,416.25	$199,080.00	-$18,663.75	2014
Small Business	Canada	Amarilla	High	888	$260.00	$300.00	$266,400.00	$229,104.00	$222,000.00	$7,104.00	2014
Midmarket	Canada	Amarilla	High	1743	$260.00	$15.00	$26,145.00	$22,484.70	$17,430.00	$5,054.70	2013
Government	Canada	Carretera	None	1618.5	$3.00	$20.00	$32,370.00	$32,370.00	$16,185.00	$16,185.00	2014
Channel Partners	Canada	Carretera	Low	1445	$3.00	$12.00	$17,340.00	$17,166.60	$4,335.00	$12,831.60	2014
Enterprise	Canada	Carretera	Low	742.5	$3.00	$125.00	$92,812.50	$90,956.25	$89,100.00	$1,856.25	2014
Channel Partners	Canada	Carretera	Low	1295	$3.00	$12.00	$15,540.00	$15,229.20	$3,885.00	$11,344.20	2014
Government	Canada	Carretera	Low	2852	$3.00	$350.00	$998,200.00	$978,236.00	$741,520.00	$236,716.00	2014
Channel Partners	Canada	Carretera	Low	908	$3.00	$12.00	$10,896.00	$10,569.12	$2,724.00	$7,845.12	2013
Government	Canada	Carretera	Low	831	$3.00	$20.00	$16,620.00	$16,121.40	$8,310.00	$7,811.40	2014
Government	Canada	Carretera	Low	2851	$3.00	$7.00	$19,957.00	$19,158.72	$14,255.00	$4,903.72	2013
Midmarket	Canada	Carretera	Medium	2844	$3.00	$15.00	$42,660.00	$40,100.40	$28,440.00	$11,660.40	2014
Channel Partners	Canada	Carretera	Medium	2299	$3.00	$12.00	$27,588.00	$25,932.72	$6,897.00	$19,035.72	2013
Channel Partners	Canada	Carretera	Medium	1884	$3.00	$12.00	$22,608.00	$21,025.44	$5,652.00	$15,373.44	2014
Small Business	Canada	Carretera	Medium	1094	$3.00	$300.00	$328,200.00	$298,662.00	$273,500.00	$25,162.00	2014
Government	Canada	Carretera	Medium	819	$3.00	$7.00	$5,733.00	$5,217.03	$4,095.00	$1,122.03	2014
Channel Partners	Canada	Carretera	High	1937	$3.00	$12.00	$23,244.00	$20,687.16	$5,811.00	$14,876.16	2014
Midmarket	Canada	Carretera	High	1560	$3.00	$15.00	$23,400.00	$20,826.00	$15,600.00	$5,226.00	2013
Enterprise	Canada	Carretera	High	2416	$3.00	$125.00	$302,000.00	$265,760.00	$289,920.00	-$24,160.00	2013
Midmarket	Canada	Carretera	High	2689	$3.00	$15.00	$40,335.00	$35,494.80	$26,890.00	$8,604.80	2014
Government	Canada	Carretera	High	923	$3.00	$350.00	$323,050.00	$281,053.50	$239,980.00	$41,073.50	2014
Small Business	Canada	Carretera	High	1496	$3.00	$300.00	$448,800.00	$385,968.00	$374,000.00	$11,968.00	2014
Midmarket	Canada	Carretera	High	2300	$3.00	$15.00	$34,500.00	$29,670.00	$23,000.00	$6,670.00	2014
Channel Partners	Canada	Montana	None	2518	$5.00	$12.00	$30,216.00	$30,216.00	$7,554.00	$22,662.00	2014
Enterprise	Canada	Montana	None	2665.5	$5.00	$125.00	$333,187.50	$333,187.50	$319,860.00	$13,327.50	2014
Enterprise	Canada	Montana	None	345	$5.00	$125.00	$43,125.00	$43,125.00	$41,400.00	$1,725.00	2013
Government	Canada	Montana	Low	1830	$5.00	$7.00	$12,810.00	$12,681.90	$9,150.00	$3,531.90	2014
Midmarket	Canada	Montana	Low	1967	$5.00	$15.00	$29,505.00	$28,324.80	$19,670.00	$8,654.80	2014
Government	Canada	Montana	Low	2851	$5.00	$7.00	$19,957.00	$19,158.72	$14,255.00	$4,903.72	2013
Government	Canada	Montana	Medium	488	$5.00	$7.00	$3,416.00	$3,142.72	$2,440.00	$702.72	2014
Government	Canada	Montana	Medium	708	$5.00	$20.00	$14,160.00	$13,027.20	$7,080.00	$5,947.20	2014
Small Business	Canada	Montana	Medium	1283	$5.00	$300.00	$384,900.00	$354,108.00	$320,750.00	$33,358.00	2013
Small Business	Canada	Montana	Medium	3802.5	$5.00	$300.00	$1,140,750.00	$1,038,082.50	$950,625.00	$87,457.50	2014
Channel Partners	Canada	Montana	Medium	2321	$5.00	$12.00	$27,852.00	$25,345.32	$6,963.00	$18,382.32	2014
Government	Canada	Montana	Medium	1611	$5.00	$7.00	$11,277.00	$10,262.07	$8,055.00	$2,207.07	2013
Government	Canada	Montana	High	2734	$5.00	$7.00	$19,138.00	$16,841.44	$13,670.00	$3,171.44	2014
Government	Canada	Montana	High	1249	$5.00	$20.00	$24,980.00	$21,732.60	$12,490.00	$9,242.60	2014
Government	Canada	Montana	High	2227.5	$5.00	$350.00	$779,625.00	$670,477.50	$579,150.00	$91,327.50	2014
Government	Canada	Montana	High	200	$5.00	$350.00	$70,000.00	$60,200.00	$52,000.00	$8,200.00	2014
Government	Canada	Montana	High	388	$5.00	$7.00	$2,716.00	$2,335.76	$1,940.00	$395.76	2014
Midmarket	Canada	Montana	High	2300	$5.00	$15.00	$34,500.00	$29,670.00	$23,000.00	$6,670.00	2014
Government	Canada	Paseo	None	292	$10.00	$20.00	$5,840.00	$5,840.00	$2,920.00	$2,920.00	2014
Channel Partners	Canada	Paseo	None	2518	$10.00	$12.00	$30,216.00	$30,216.00	$7,554.00	$22,662.00	2014
Government	Canada	Paseo	None	1725	$10.00	$350.00	$603,750.00	$603,750.00	$448,500.00	$155,250.00	2013
Midmarket	Canada	Paseo	None	2152	$10.00	$15.00	$32,280.00	$32,280.00	$21,520.00	$10,760.00	2013
Government	Canada	Paseo	None	1817	$10.00	$20.00	$36,340.00	$36,340.00	$18,170.00	$18,170.00	2014
Midmarket	Canada	Paseo	Low	2363	$10.00	$15.00	$35,445.00	$34,736.10	$23,630.00	$11,106.10	2014
Channel Partners	Canada	Paseo	Low	1295	$10.00	$12.00	$15,540.00	$15,229.20	$3,885.00	$11,344.20	2014
Small Business	Canada	Paseo	Low	1916	$10.00	$300.00	$574,800.00	$563,304.00	$479,000.00	$84,304.00	2014
Government	Canada	Paseo	Low	2852	$10.00	$350.00	$998,200.00	$978,236.00	$741,520.00	$236,716.00	2014
Enterprise	Canada	Paseo	Low	2729	$10.00	$125.00	$341,125.00	$334,302.50	$327,480.00	$6,822.50	2014
Enterprise	Canada	Paseo	Low	1774	$10.00	$125.00	$221,750.00	$215,097.50	$212,880.00	$2,217.50	2014
Enterprise	Canada	Paseo	Low	2009	$10.00	$125.00	$251,125.00	$243,591.25	$241,080.00	$2,511.25	2014
Government	Canada	Paseo	Low	4251	$10.00	$7.00	$29,757.00	$28,566.72	$21,255.00	$7,311.72	2014
Midmarket	Canada	Paseo	Low	218	$10.00	$15.00	$3,270.00	$3,139.20	$2,180.00	$959.20	2014
Government	Canada	Paseo	Low	2074	$10.00	$20.00	$41,480.00	$39,820.80	$20,740.00	$19,080.80	2014
Government	Canada	Paseo	Medium	2349	$10.00	$7.00	$16,443.00	$15,620.85	$11,745.00	$3,875.85	2013
Channel Partners	Canada	Paseo	Medium	2431	$10.00	$12.00	$29,172.00	$27,713.40	$7,293.00	$20,420.40	2014
Government	Canada	Paseo	Medium	1228	$10.00	$350.00	$429,800.00	$408,310.00	$319,280.00	$89,030.00	2013
Government	Canada	Paseo	Medium	1389	$10.00	$20.00	$27,780.00	$26,391.00	$13,890.00	$12,501.00	2013
Government	Canada	Paseo	Medium	1802	$10.00	$20.00	$36,040.00	$34,238.00	$18,020.00	$16,218.00	2013
Channel Partners	Canada	Paseo	Medium	2299	$10.00	$12.00	$27,588.00	$25,932.72	$6,897.00	$19,035.72	2013
Small Business	Canada	Paseo	Medium	1702	$10.00	$300.00	$510,600.00	$474,858.00	$425,500.00	$49,358.00	2014
Small Business	Canada	Paseo	Medium	1404	$10.00	$300.00	$421,200.00	$391,716.00	$351,000.00	$40,716.00	2013
Government	Canada	Paseo	Medium	257	$10.00	$7.00	$1,799.00	$1,655.08	$1,285.00	$370.08	2014
Small Business	Canada	Paseo	Medium	1094	$10.00	$300.00	$328,200.00	$298,662.00	$273,500.00	$25,162.00	2014
Small Business	Canada	Paseo	High	873	$10.00	$300.00	$261,900.00	$233,091.00	$218,250.00	$14,841.00	2014
Government	Canada	Paseo	High	2104.5	$10.00	$350.00	$736,575.00	$655,551.75	$547,170.00	$108,381.75	2014
Channel Partners	Canada	Paseo	High	4026	$10.00	$12.00	$48,312.00	$42,997.68	$12,078.00	$30,919.68	2014
Government	Canada	Paseo	High	2394	$10.00	$20.00	$47,880.00	$42,613.20	$23,940.00	$18,673.20	2014
Small Business	Canada	Paseo	High	1366	$10.00	$300.00	$409,800.00	$364,722.00	$341,500.00	$23,222.00	2014
Government	Canada	Paseo	High	2632	$10.00	$350.00	$921,200.00	$801,444.00	$684,320.00	$117,124.00	2014
Enterprise	Canada	Paseo	High	1583	$10.00	$125.00	$197,875.00	$172,151.25	$189,960.00	-$17,808.75	2014
Midmarket	Canada	Paseo	High	1565	$10.00	$15.00	$23,475.00	$20,423.25	$15,650.00	$4,773.25	2014
Government	Canada	Paseo	High	1249	$10.00	$20.00	$24,980.00	$21,732.60	$12,490.00	$9,242.60	2014
Government	Canada	Paseo	High	2428	$10.00	$20.00	$48,560.00	$41,761.60	$24,280.00	$17,481.60	2014
Midmarket	Canada	Paseo	High	2470	$10.00	$15.00	$37,050.00	$31,863.00	$24,700.00	$7,163.00	2013
Midmarket	Canada	Paseo	High	1743	$10.00	$15.00	$26,145.00	$22,484.70	$17,430.00	$5,054.70	2013
Government	Canada	Paseo	High	700	$10.00	$350.00	$245,000.00	$210,700.00	$182,000.00	$28,700.00	2014
Channel Partners	Canada	Paseo	High	2222	$10.00	$12.00	$26,664.00	$22,931.04	$6,666.00	$16,265.04	2013
Midmarket	Canada	Paseo	High	1614	$10.00	$15.00	$24,210.00	$20,578.50	$16,140.00	$4,438.50	2014
Midmarket	Canada	Paseo	High	2559	$10.00	$15.00	$38,385.00	$32,627.25	$25,590.00	$7,037.25	2014
Government	Canada	Paseo	High	723	$10.00	$7.00	$5,061.00	$4,301.85	$3,615.00	$686.85	2014
Enterprise	Canada	Velo	None	345	$120.00	$125.00	$43,125.00	$43,125.00	$41,400.00	$1,725.00	2013
Enterprise	Canada	Velo	Low	923	$120.00	$125.00	$115,375.00	$114,221.25	$110,760.00	$3,461.25	2014
Government	Canada	Velo	Low	2092	$120.00	$7.00	$14,644.00	$14,497.56	$10,460.00	$4,037.56	2013
Enterprise	Canada	Velo	Low	2009	$120.00	$125.00	$251,125.00	$243,591.25	$241,080.00	$2,511.25	2014
Government	Canada	Velo	Low	3850.5	$120.00	$20.00	$77,010.00	$74,699.70	$38,505.00	$36,194.70	2014
Government	Canada	Velo	Low	2646	$120.00	$20.00	$52,920.00	$50,803.20	$26,460.00	$24,343.20	2013
Channel Partners	Canada	Velo	Medium	2431	$120.00	$12.00	$29,172.00	$27,713.40	$7,293.00	$20,420.40	2014
Enterprise	Canada	Velo	Medium	952	$120.00	$125.00	$119,000.00	$111,860.00	$114,240.00	-$2,380.00	2014
Midmarket	Canada	Velo	Medium	1262	$120.00	$15.00	$18,930.00	$17,604.90	$12,620.00	$4,984.90	2014
Government	Canada	Velo	Medium	1135	$120.00	$7.00	$7,945.00	$7,388.85	$5,675.00	$1,713.85	2014
Government	Canada	Velo	Medium	1582	$120.00	$7.00	$11,074.00	$10,298.82	$7,910.00	$2,388.82	2014
Channel Partners	Canada	Velo	Medium	598	$120.00	$12.00	$7,176.00	$6,601.92	$1,794.00	$4,807.92	2014
Small Business	Canada	Velo	Medium	3793.5	$120.00	$300.00	$1,138,050.00	$1,035,625.50	$948,375.00	$87,250.50	2014
Enterprise	Canada	Velo	Medium	567	$120.00	$125.00	$70,875.00	$64,496.25	$68,040.00	-$3,543.75	2014
Government	Canada	Velo	Medium	1269	$120.00	$350.00	$444,150.00	$404,176.50	$329,940.00	$74,236.50	2014
Enterprise	Canada	Velo	High	1916	$120.00	$125.00	$239,500.00	$215,550.00	$229,920.00	-$14,370.00	2013
Midmarket	Canada	Velo	High	384	$120.00	$15.00	$5,760.00	$5,126.40	$3,840.00	$1,286.40	2014
Government	Canada	Velo	High	1808	$120.00	$7.00	$12,656.00	$11,263.84	$9,040.00	$2,223.84	2014
Government	Canada	Velo	High	2632	$120.00	$350.00	$921,200.00	$801,444.00	$684,320.00	$117,124.00	2014
Small Business	Canada	Velo	High	269	$120.00	$300.00	$80,700.00	$69,402.00	$67,250.00	$2,152.00	2013
Small Business	Canada	VTT	None	2001	$250.00	$300.00	$600,300.00	$600,300.00	$500,250.00	$100,050.00	2014
Government	Canada	VTT	None	1817	$250.00	$20.00	$36,340.00	$36,340.00	$18,170.00	$18,170.00	2014
Government	Canada	VTT	Low	1326	$250.00	$7.00	$9,282.00	$9,189.18	$6,630.00	$2,559.18	2014
Government	Canada	VTT	Low	943.5	$250.00	$350.00	$330,225.00	$326,922.75	$245,310.00	$81,612.75	2014
Enterprise	Canada	VTT	Low	2729	$250.00	$125.00	$341,125.00	$334,302.50	$327,480.00	$6,822.50	2014
Small Business	Canada	VTT	Low	1874	$250.00	$300.00	$562,200.00	$545,334.00	$468,500.00	$76,834.00	2014
Government	Canada	VTT	Medium	1389	$250.00	$20.00	$27,780.00	$26,391.00	$13,890.00	$12,501.00	2013
Midmarket	Canada	VTT	Medium	2844	$250.00	$15.00	$42,660.00	$40,100.40	$28,440.00	$11,660.40	2014
Small Business	Canada	VTT	Medium	2436	$250.00	$300.00	$730,800.00	$686,952.00	$609,000.00	$77,952.00	2013
Government	Canada	VTT	Medium	1582	$250.00	$7.00	$11,074.00	$10,298.82	$7,910.00	$2,388.82	2014
Channel Partners	Canada	VTT	Medium	3244.5	$250.00	$12.00	$38,934.00	$36,208.62	$9,733.50	$26,475.12	2014
Small Business	Canada	VTT	Medium	2134	$250.00	$300.00	$640,200.00	$588,984.00	$533,500.00	$55,484.00	2014
Enterprise	Canada	VTT	High	2529	$250.00	$125.00	$316,125.00	$284,512.50	$303,480.00	-$18,967.50	2014
Government	Canada	VTT	High	2935	$250.00	$20.00	$58,700.00	$52,243.00	$29,350.00	$22,893.00	2013
Channel Partners	Canada	VTT	High	2109	$250.00	$12.00	$25,308.00	$22,271.04	$6,327.00	$15,944.04	2014
Government	Canada	VTT	High	623	$250.00	$350.00	$218,050.00	$191,884.00	$161,980.00	$29,904.00	2013
Enterprise	Canada	VTT	High	1583	$250.00	$125.00	$197,875.00	$172,151.25	$189,960.00	-$17,808.75	2014
Midmarket	Canada	VTT	High	1565	$250.00	$15.00	$23,475.00	$20,423.25	$15,650.00	$4,773.25	2014
Small Business	Canada	VTT	High	269	$250.00	$300.00	$80,700.00	$69,402.00	$67,250.00	$2,152.00	2013
Small Business	Canada	VTT	High	1496	$250.00	$300.00	$448,800.00	$385,968.00	$374,000.00	$11,968.00	2014
Government	Canada	VTT	High	865.5	$250.00	$20.00	$17,310.00	$14,713.50	$8,655.00	$6,058.50	2014
Enterprise	Canada	VTT	High	2954	$250.00	$125.00	$369,250.00	$313,862.50	$354,480.00	-$40,617.50	2013

Screenshot 2023-01-29 at 10.19.12 AM.png

Screenshot 2023-01-29 at 10.19.33 AM.png

Screenshot 2023-01-29 at 10.20.21 AM.png

Screenshot 2023-01-29 at 10.20.41 AM.png