(8 points) A data set has 30 different variables containing statistics on 797 ba
ID: 3700822 • Letter: #
Question
(8 points) A data set has 30 different variables containing statistics on 797 baseball players for Atlanta, Baltimore, and Boston in November 2004. Several of the statistics are important to you. You would like to know the different positions (position is a qualitative data) and the number of players who have those positions; the average salary number of hits, and errors per team (team is a qualitative data) for Atlanta (ATL), Baltimore (BAL), and Boston (BOS) The player (player is a qualitative data) is also in this data set. 12.If I wanted to see how many players are left fielders (LF) I could use which of the following codes: a. Code a: DATA BASEBALL; INFILE 'C:USERSSUEDESKTOPBASEBALL . CSV ' INPUT DELIMITER = ', ' DSD; TEAM $ PLAYER $ SALARY POSITION $ ERRORS HITS? RUN PROC COUNTS DATA -BASEBALL; VAR POSITION LF; RUNExplanation / Answer
1.Code a is correct.
Using SQL we can create new data set form raw data given above,such that the dataset name is Baseball.
We are taking the inputs
Team
Player
Salary
Position
Errors
Hits
All these are considered as the inptuts for the data set.Then we are creating a procedure that takes the count of baseball players by only considering the left fielders,such that we have specified a condition var LF.There by running the code.Such that the code returns the players who are left fielders.
2.All the remaining code in the above haven't not specified the condition of players with left fielders.So the code doesn't return the players with left fielders.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.