Learning Activity #4: Team Project: Scatterplot/Sparklines

Order Description Objective 3: Create a scatterplot to visually present analytical data. Finding a relationship between two different variables can be done in a variety of ways. Companies are always looking for possible ways that one variable impacts another. In Week Two you used predictive modeling relating Net Profit to Sales. A scatterplot (or scatter chart) plots information at different times in order to visually see relationships. Bartlett (2013) compares actual sales to projected sales. Sharma (n.d.) provides some additional insights into how a scatterplot (scatter chart) is developed. Sharma, H. (n.d.). How to select best excel charts for your data analysis & reporting. Retrieved from https://www.seotakeaways.com/how-to-select-best-excel-charts-for-your-data-analysis-reporting/ Learning Activity #4: Team Project: Scatterplot/Sparklines Using a scatterplot (scatter chart) complete a comparison of annual Net Profit for the publicly traded company your team has been studying for the last seven years to two of its competitors. After completing the scatterplot, apply the use of sparklines to the data collected for all three companies. Information on adding sparklines is found at https://office.microsoft.com/en-us/excel-help/use-sparklines-to-show-data-trends-HA010354892.aspx) In a one-page summary, review both the tools used and the information gained in comparing the three companies. Use the Team rubric provided in your syllabus to guide your collaboration efforts. The points in the Team rubric represent only your collaboration. The remaining points assigned to this activity will represent the quality of the work. Have one member of the team submit the completed assignment to your facilitator as an attachment in the drop box titled Team Scatterpoint/Sparklines.