Best writers. Best papers. Let professionals take care of your academic papers

Order a similar paper and get 15% discount on your first order with us
Use the following coupon "FIRST15"
ORDER NOW

Data-Analytics-Exercise

/in /by

In this exercise, we will compare doing an analysis on the same data in Excel and SAS, and then report on our analysis.The data that we will use for this analysis is called BASEBALL, and the analysis we will do is an ANOVA.

An ANOVA is a set of statistical methods used mainly to compare the means of two or more samples. Estimates of variance are the key intermediate statistics calculated, hence the reference to variance in the title ANOVA.

Please watch the video linked to this module for detailed instructions. In general, you are going to:

  1. Open SAS
  2. Find the BASEBALL data
  3. Explore the BASEBALL data
  4. Select the ANOVA task
  5. Perform an ANOVA on the BASEBALL data looking at player position (1B, 2B, and 3B) and player salaries. Are they salaries of these three positions statistically different in the given data set?
  6. Download the “BASEBALL.xlsx” data set from this assignment (It should be the same data as is located in the SAS files).
  7. Download the “Business Memo Template.docx”.
  8. Open Excel. If you have not already done so, enable the Data Analysis tools in Excel.
  9. Open the BASEBALL.xlsx data file in Excel.
  10. Prepare the data for analysis in Excel (Excel requires the data be in columns)
  11. Perform an ANOVA on the BASEBALL data looking at player position (1B, 2B, and 3B) and player salaries. Are the salaries of these three positions statistically different in the given data set?
  12. Compare the results from both Excel and SAS.
  13. Open Word. Open the “Business Memo Template.docx” file and prepare your report. Your report should not exceed two pages, have at least one table, and one graphic. The last paragraph should be a recommendation on the pay for these players. Be creative, but use information from your analysis to support your recommendation.
  14. Save your Word file as “LastName DAX4” without the quotation marks. The file extension will be added automatically. For example, my file would be “Bohler DAX3.docx”. Again, ignore the quotation marks in the instructions.
  15. Upload your completed Business Memo to this assignment.
  16. http://is3310videos.com/indirect2.html?video=8
  17. http://is3310videos.com/indirect2.html?video=15
 
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"