Reference no: EM132787945
ALY 6000 Introduction to Analytics - Northeastern University
Executive Summary Report
Dataset Instructions
Complete the following instructions to create the dataset and output required for the Executive Summary Report in Module 2. The output you create from the following steps must be incorporated into your report. Be sure to save your R script file with the following naming convention:
LastName_M2_Project2
Append your completed R-Script to the Executive Summary
Instructions
To complete this assignment you must create an R script file that includes the code required to complete the following steps:
1. Print your name at the top of the script. Include the prefix: "Plotting Basics:" such that it appears "Plotting Basics: Lastname"
2. Import libraries including: FSA, FSAdata, magrittr, dplyr, plotrix, ggplot2, and moments NOTE: You must use R version 3.6.3 to gain access to the FSA data set. If you installed a later version of R, you must uninstall Rstudio and R. Then reinstall R version 3.6.3; then reinstall Rstudio.
3. Load the BullTroutRML2 dataset (BullTroutRML2.csv)
NOTE: The dataset is already imported into your project when you added the FSA and FSAdata libraries.
4. Print the first and last 3 records from the BullTroutRMS2 dataset
5. Remove all records except those from Harrison Lake (hint: use the <filterD() function)
NOTE: From this point forward any reference to BullTroutRML2 always refers to the filtered dataset (Harrison Lake only data is used). You may choose to rename the dataset at this point.
6. Display the first and last 5 records from the filtered BullTroutRML2 dataset
7. Display the structure of the filtered BullTroutRML2dataset
8. Display the summary of the filtered BullTroutRML2dataset
9. Create a scatterplot for "age" (y variable) and "fl" (x variable) with the following specifications:
• Limit of x axis is (0,500)
• Limit of y axis is (0,15)
• Title of graph is "Plot 1: Harrison Lake Trout
• Y axis label is "Age (yrs)"
• X axis label is "Fork Length (mm)"
• Use a small filled circle for the plotted data points
10. Plot an "Age" histogram with the following specifications
• Y axis label is "Frequency"
• X axis label is "Age (yrs)"
• Title of the histogram is "Plot 2: Harrison Fish Age Distribution" X and Y axis limits is 0, 15
• The color of the frequency plots is "cadetblue"
• The color of the Title is "cadetblue"
11. Create an overdense plot using the same specifications as the previous scatterplot. But,
• Title the plot "Plot 3: Harrison Density Shaded by Era"
• Y axis label is "Age (yrs)"
• Y axis limits are 0 to 15
• X axis label is "Fork Length (mm)"
• X axis limits are 0 to 500
• include two levels of shading for the "green" data points.
• Plot solid circles as data points
12. Create a new object called "tmp" that includes the first 3 and last 3 records of the BullTroutRML2 data set.
13. Display the "era" column (variable) in the new "tmp" object
14. Create a pchs vector with the argument values for + and x.
15. Create a cols vector with the two elements "red" and "gray60"
16. Convert the tmp era values to numeric values.
17. Initialize the cols vector with the tmp era values
18. Create a plot of "Age (yrs)" (y variable) versus "Fork Length (mm)" (x variable) with the following specifications:
• Title of graph is "Plot 4: Symbol & Color by Era"
• Limit of x axis is (0,500)
• Limit of y axis is (0,15)
• X axis label is "Age (yrs)"
• Y axis label is "Fork Length (mm)"
• Set pch equal to pchs era values
• Set col equal to cols era values
19. Plot a regression line overlay on Plot 4 and title the new graph "Plot 5: Regression Overlay".
20. Place a legend of on Plot 5 and call the new graph "Plot 6: :Legend Overlay"
Overview and Rationale
As a data analyst, you will need to be able to create understandable data visualizations and clearly summarize the data for executives. This assignment allows you to demonstrate your skills to process data, present the data visually, and calculate basic; all with explanatory analysis.
Module Outcomes
This assignment links directly to the following learning outcomes from this module:
? Calculate basic descriptive statistics to describe a set of data
? Create various types of graph based on data provided
? Use R to visualize data
? Explain the significance of calculate statistics and graphs
Assignment Summary
In this assignment, you will create an executive summary based on a set of data provided by your instructor. You will write and execute an R script in order to gather the information required to complete your report. You are provided with an assignment instruction document (Module 2 Project Instructions) to guide the R-code you need to write an Executive Summary specified below.
Your Executive Summary should consist of:
Page 1: Title Page: name, date, title
Pages 2-4: Key Findings about the data. (Content outlined the assignment below and in the Project Instructions)
Page 5: Bibliography: This includes Youtube videos, instruction materials, google search results, texts that informed your study of statistics and R. Adhere to APA standards.
Page 6: Appendix: The R Script you wrote and executed.
There are three aspects of this assignment as follows:
A. Provide an analysis of descriptive characteristics of the data set provided by your instructor. This includes pertinent statistics including mean, median, quartiles,
variance, standard deviation, skew, kurtosis, outliers etc. Include R console screen shots to support your observations and conclusions. Below is a sample excerpt of an analysis of Harrison Lake fish from the BullTroutRML2 dataset.
B. Provide the executive with visualizations (at least 6) in that help them see the key characteristics you want to highlight. They can be boxplots, histograms, frequency and probability distributions, barplots (bar charts) or pareto. Not only is the goal to present your visual results, but also to explain the significance of what the visuals are displaying.
C. Finally, provide a clear two to three sentence paragraph summary of the key points that you want the audience to walk away with regarding your analysis. This summary should present accurate analysis and be supported by the data presented in the rest of the report.
Instructions
Using the assignment instruction document (Module 2 Project Instructions), complete the assignment above.
Supporting Files
To complete this assignment you will need to download the following file: Module 2 Project Instructions.pdf
What to Submit
Submit a single file with the following title: LastName_M2_Project2.pdf
There are three aspects of this assignment as follows:
Provide an analysis of descriptive characteristics of the data set provided by your instructor. This includes pertinent statistics including mean, median, quartiles, variance, standard deviation, skew, kurtosis, outliers etc. Include R console screen shots to support your observations and conclusions. Below is a sample excerpt of an analysis of Harrison Lake fish from the BullTroutRML2 dataset.
Provide the executive with visualizations (at least 6) in that help them see the key characteristics you want to highlight. They can be boxplots, histograms, frequency and probability distributions, barplots (bar charts) or pareto. Not only is the goal to present your visual results, but also to explain the significance of what the visuals are displaying.
Finally, provide a clear two to three sentence paragraph summary of the key points that you want the audience to walk away with regarding your analysis. This summary should present accurate analysis and be supported by the data presented in the rest of the report.
Attachment:- Executive Summary Report.rar