business analytics

Raw Data

Year	Month	State	Sales	Costs
2021	Jan	IL	576	490
2021	Jan	IN	293	279
2021	Jan	WI	355	310
2021	Feb	IL	552	501
2021	Feb	IN	286	295
2021	Feb	WI	347	278
2021	Mar	IL	593	437
2021	Mar	IN	312	298
2021	Mar	WI	415	389
2021	Apr	IL	589	472
2021	Apr	IN	302	213
2021	Apr	WI	406	308
2021	May	IL	612	399
2021	May	IN	319	210
2021	May	WI	459	345
2021	Jun	IL	619	410
2021	Jun	IN	457	270
2021	Jun	WI	501	412
2021	Jul	IL	647	428
2021	Jul	IN	498	317
2021	Jul	WI	523	410
2021	Aug	IL	632	456
2021	Aug	IN	480	324
2021	Aug	WI	518	367
2021	Sep	IL	607	421
2021	Sep	IN	465	365
2021	Sep	WI	502	378
2021	Oct	IL	589	412
2021	Oct	IN	410	249
2021	Oct	WI	479	334
2021	Nov	IL	571	420
2021	Nov	IN	351	318
2021	Nov	WI	455	387
2021	Dec	IL	529	425
2021	Dec	IN	312	356
2021	Dec	WI	410	301
2022	Jan	IL	598	374
2022	Jan	IN	329	305
2022	Jan	WI	378	327
2022	Feb	IL	548	417
2022	Feb	IN	367	303
2022	Feb	WI	398	342
2022	Mar	IL	612	421
2022	Mar	IN	385	356
2022	Mar	WI	445	386
2022	Apr	IL	613	418
2022	Apr	IN	367	317
2022	Apr	WI	378	340
2022	May	IL	683	526
2022	May	IN	419	335
2022	May	WI	502	359
2022	Jun	IL	689	421
2022	Jun	IN	490	379
2022	Jun	WI	524	416
2022	Jul	IL	705	504
2022	Jul	IN	537	407
2022	Jul	WI	526	439
2022	Aug	IL	708	427
2022	Aug	IN	599	319
2022	Aug	WI	487	410
2022	Sep	IL	659	429
2022	Sep	IN	563	467
2022	Sep	WI	552	373
2022	Oct	IL	613	481
2022	Oct	IN	490	280
2022	Oct	WI	511	400
2022	Nov	IL	612	455
2022	Nov	IN	498	369
2022	Nov	WI	463	278
2022	Dec	IL	588	385
2022	Dec	IN	471	332
2022	Dec	WI	459	301

Questions

Number	Question	Answer
1	What is your full name?
2	What is the total Sales generated in each state? (use "=SUMIF")(Do it separately for IL, IN, WI)
3	Make a pie chart to show the shares of each state in total Sales.
4	What is the total Costs generated in 2021? (use "=SUMIF")
5	What is the total number of times that the sales are less than 450? (use "=Countif")
6	Calculate the correlation coefficient between Sales and Profit (use "=CORREL").
7	Make a scatter plot with Sales on the X-axis and Profit on the Y-axis.