06 Feb You applied some excel analytic tools in Module 3. The data was provided as were the solutions and some discussion about t
You applied some excel analytic tools in Module 3. The data was provided as were the solutions and some discussion about those results. This provided you the opportunity to apply and practice using the tools and techniques. For your Module 4 Data Assignment, obtain your own data, and replicate one of the analyses you performed in Module 3. This will depend upon what type of data you obtain. That is part of quantitative methods; you have to make sure the tools you use are the correct tools
Data could come from online sources. Perhaps, you have some data from a work project in which you want to use or have a topic you are interested in and can obtain some data to perform the appropriate analysis.
In this assignment, you will also need to write a short paper on your data analysis. Provide a brief description of the phenomena the data is generated from, describe the data, provide any necessary summary statistics. Briefly describe the data and what is being examined, where/how did you get the data (include a link to the data), and provide 2 to 3 paragraphs explaining your interpretation of the data and a conclusion. There is not an APA requirement for this assignment. All margins should be 1 inch. Line spacing should be 1.5. Font should be 12-point Arial. Indent new paragraphs an additional 1/2 inch.
Sheet1
| Qtr 1 | Qtr 2 | Qtr 3 | Qtr 4 | Yearly total | |
| Yr1 | 23 | 14 | 56 | 78 | 171 |
| Yr2 | 27 | 20 | 67 | 89 | 203 |
| Yr3 | 34 | 30 | 73 | 83 | 220 |
| Yr4 | 43 | 32 | 85 | 98 | 258 |
| Yr5 | 50 | 36 | 101 | 123 | 310 |
| Yr6 | 63 | 46 | 125 | 146 | 380 |
Product E
Qtr 1 Yr1 Yr2 Yr3 Yr4 Yr5 Yr6 23 27 34 43 50 63 Qtr 2 Yr1 Yr2 Yr3 Yr4 Yr5 Yr6 14 20 30 32 36 46 Qtr 3 Yr1 Yr2 Yr3 Yr4 Yr5 Yr6 56 67 73 85 101 125 Qtr 4 Yr1 Yr2 Yr3 Yr4 Yr5 Yr6 78 89 83 98 123 146 Yearly total Yr1 Yr2 Yr3 Yr4 Yr5 Yr6 171 203 220 258 310 380
Qtrs
From this graph, we can see that the 3rd and 4th quarter sales are much higher than the 1st and 2nd quarters. We can also see that sales increase every year through the Yearly Total line. If the yearly total was also displayed as a bar graph, it would have been very difficult to see quarterly information. However, it is easier to see by displaying quarterly sales as a bar and displaying yearly total and 1st quarter sales as a line graph.
