05 Feb You applied some excel analytic tools in Module 3. The data was provided as were the solutions and some discussion about th
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.
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.