INFO HW
danya.alsinan
INFO1010-Project1Winter2018.xlsxProject 1 Overview
| INFO 1010: Project 1: Sales Data Analysis Congratulations! You have been hired by Lisa Jones to help run her documentary production company. In this spreadsheet you will find the sales amounts of her sales force. Lisa would like you to analyze the data and provide her with an understanding of how her sales representatives are currently performing. Please be sure to demonstrate bar charts, pie charts, and histograms in your analysis. Your analysis will include a word document with your managerial report and all charts and graphs must be in the word document. You will also submit your Excel spreadsheet. Be sure to watch formatting and look for trends or other analysis you can find in the data. Be sure to upload both your word managerial report and your excel spreadsheet. If you have trouble uploading change your browser - Canvas does not always work well with Chrome - I suggest FireFox. | |||
Data
| Sales Representative | Year | January | February | March | April | May | ||
| Lebron | 2020 | $ 870,000 | $ 677,000 | $ 665,000 | $ 627,000 | $ 570,000 | ||
| Wade | 2020 | $ 840,000 | $ 647,000 | $ 755,000 | $ 797,000 | $ 860,000 | ||
| Dirk | 2020 | $ 470,000 | $ 1,017,000 | $ 1,165,000 | $ 1,287,000 | $ 1,510,000 | ||
| Manning | 2020 | $ 770,000 | $ 897,000 | $ 905,000 | $ 777,000 | $ 840,000 | ||
| Brady | 2020 | $ 980,000 | $ 917,000 | $ 995,000 | $ 467,000 | $ 940,000 | ||
| Halliday | 2020 | $ 770,000 | $ 747,000 | $ 805,000 | $ 927,000 | $ 960,000 | ||
| Britney | 2020 | $ 1,000,000 | $ 927,000 | $ 1,105,000 | $ 1,007,000 | $ 850,000 | ||
| Lindsay | 2020 | $ 850,000 | $ 857,000 | $ 985,000 | $ 827,000 | $ 990,000 | ||
| Paris | 2020 | $ 1,080,000 | $ 997,000 | $ 855,000 | $ 947,000 | $ 830,000 | ||
| JLO | 2020 | $ 1,060,000 | $ 897,000 | $ 1,105,000 | $ 1,027,000 | $ 1,160,000 | ||
| Emma | 2020 | $ 1,170,000 | $ 957,000 | $ 1,065,000 | $ 1,027,000 | $ 1,080,000 | ||
| Melo | 2020 | $ 1,200,000 | $ 997,000 | $ 1,295,000 | $ 1,277,000 | $ 1,090,000 | ||
| KD | 2020 | $ 1,160,000 | $ 1,157,000 | $ 1,055,000 | $ 1,177,000 | $ 1,320,000 | ||
| Flynn | 2020 | $ 1,140,000 | $ 1,237,000 | $ 1,035,000 | $ 676,000 | $ 1,080,000 | ||
| Rodgers | 2020 | $ 1,290,000 | $ 1,157,000 | $ 1,175,000 | $ 1,407,000 | $ 1,090,000 | ||
| Lebron | 2021 | $ 955,000 | $ 578,000 | $ 570,000 | $ 353,000 | $ 345,000 | ||
| Wade | 2021 | $ 922,000 | $ 552,500 | $ 865,000 | $ 601,000 | $ 760,000 | ||
| Dirk | 2021 | $ 515,000 | $ 867,000 | $ 1,625,000 | $ 1,769,000 | $ 1,510,000 | ||
| Manning | 2021 | $ 845,000 | $ 765,000 | $ 1,261,000 | $ 1,271,000 | $ 1,362,000 | ||
| Brady | 2021 | $ 1,076,000 | $ 782,000 | $ 1,387,000 | $ 575,000 | $ 1,530,000 | ||
| Halliday | 2021 | $ 845,000 | $ 637,500 | $ 1,121,000 | $ 587,000 | $ 960,000 | ||
| Britney | 2021 | $ 1,098,000 | $ 790,500 | $ 667,000 | $ 521,000 | $ 468,000 | ||
| Lindsay | 2021 | $ 933,000 | $ 731,000 | $ 1,373,000 | $ 967,000 | $ 990,000 | ||
| Paris | 2021 | $ 1,186,000 | $ 850,000 | $ 1,191,000 | $ 509,000 | $ 466,000 | ||
| JLO | 2021 | $ 1,164,000 | $ 765,000 | $ 867,000 | $ 707,000 | $ 1,160,000 | ||
| Emma | 2021 | $ 1,285,000 | $ 1,487,000 | $ 1,485,000 | $ 1,087,000 | $ 1,080,000 | ||
| Melo | 2021 | $ 1,318,000 | $ 850,000 | $ 967,000 | $ 665,000 | $ 762,000 | ||
| KD | 2021 | $ 1,120,000 | $ 986,000 | $ 1,471,000 | $ 1,473,000 | $ 1,320,000 | ||
| Flynn | 2021 | $ 1,252,000 | $ 1,054,000 | $ 1,443,000 | $ 659,000 | $ 1,080,000 | ||
| Rodgers | 2021 | $ 1,420,000 | $ 986,000 | $ 1,639,000 | $ 1,665,000 | $ 1,090,000 |
