Assessment 2: Analytic Technicques
Resources
These recommended resources are intended to support your effort to create visual representations of the data that you have selected for review.
· Lind, D. A., Marchal, W. G., & Wathen, S. A. (2019). Basic statistics for business and economics (9th ed.). New York, NY: McGraw-Hill.
. Chapter 2, "Describing Data: Frequency Tables, Frequency Distributions, and Graphic Presentation."
. Beginning with a scenario about how a large corporation uses statistics and analytics to support business decisions, this chapter also includes instructions on how to create descriptive statistics such as frequency tables, bar charts, pie charts, histograms, and frequency polygons (line charts).
· Chapter 3, "Describing Data: Numerical Measures."
. A discussion of what average means in common conversation leads to instructions for calculating measures of location, otherwise known as the mean, median, and mode.
· Chapter 4, "Describing Data: Displaying and Exploring Data."
. Instructions for creating dot plots (scatterplots), percentiles, and box plots will provide additional insight into how data is concentrated as well as the general shape of the data.
· Chapter 5, "A Survey of Probability Concepts."
. The previous chapters on descriptive statistics concerned data on past phenomena; this section addresses determining "the chance that something will occur in the future."
· This short reading includes five sample applications of the "big 5" parameters.
· Microsoft. (n.d.). Add a pie chart . Retrieved from https://support.office.com/en-us/article/Add-a-pie-chart-1a5f08ae-ba40-46f2-9ed0-ff84873b7863?ui=en-US&rs;=en-US&ad;=US#__toc348714905
· Microsoft. (n.d.). Create a box and whisker chart . Retrieved from https://support.office.com/en-us/article/Create-a-box-and-whisker-chart-62f4219f-db4b-4754-aca8-4743f6190f0d
· Microsoft. (n.d.). Create a histogram in Excel . Retrieved from https://support.office.com/en-us/article/Create-a-histogram-in-Excel-85680173-064b-4024-b39d-80f17ff2f4e8?ui=en-US&rs;=en-US&ad;=US
· Microsoft. (n.d.). Load the Analysis ToolPak in Excel . Retrieved from https://support.office.com/en-us/article/Load-the-Analysis-ToolPak-in-Excel-6a63e598-cd6d-42e3-9317-6b40ba1a66b4?CTT=1&CorrelationId;=9f089166-5317-42d4-8d41-56b3d207e812&ui;=en-US&rs;=en-US&ad;=US
· Microsoft. (n.d.). Present your data in a column chart . Retrieved from https://support.office.com/en-us/article/Present-your-data-in-a-column-chart-d89050ba-e6b6-47de-b090-e9ab353c4c00
· Microsoft. (n.d.). Present your data in a scatter chart or a line chart . Retrieved from https://support.office.com/en-us/article/Present-your-data-in-a-scatter-chart-or-a-line-chart-4570A80F-599A-4D6B-A155-104A9018B86E
· Microsoft. (n.d.). Use the Analysis ToolPak to perform complex data analysis . Retrieved from https://support.office.com/en-us/article/Use-the-Analysis-ToolPak-to-perform-complex-data-analysis-6C67CCF0-F4A9-487C-8DEC-BDB5A2CEFAB6
These resources are optional and are provided to support and extend the learning in the course.
· Ayers, D. F. (2002). Mission priorities of community colleges in the southern United States . Community College Review, 30(3), 11–30.
· Bae, J., & Cameron, G. T. (2006). Conditioning effect of prior reputation on perception of corporate giving . Public Relations Review, 32(2), 144–150.
· Gault, J., Redington, J., & Schlager, T. (2000). Undergraduate business internships and career success: Are they related? Journal of Marketing Education, 22(1), 45–53.
· Preis, T., Moat, H. S., & Stanley, H. E. (2013). Quantifying trading behavior in financial markets using Google trends . Scientific Reports, 3(1684), 1–6.