Reference no: EM132235152

Statistical Software and Data Analysis Assignment -

1. A consumer magazine wants to create an index of cars based on the data in the file cars.dat. This index is a function of the car size, gas mileage (mileage), and reliability (reliable). The variable size has values SMALL, COMPACT, and MID-SIZED. The cars.dat data file description is as follows.

Variable	Description	Starting Column	Length	Type
SIZE	Car Size	1	9	Char
MANUFACT	Manufacturer	11	9	Char
MODEL	Model	22	9	Char
MILEAGE	Gas Mileage	38	2	Numeric
RELIABLE	Reliability	50	1	Numeric

Write a SAS DATA step to create a SAS dataset called car_inx that contains all the variables described in the cars.dat file plus the index variable. Be sure to set index to a missing value if either a mileage or reliability value is missing. The rules are as follows:

For SMALL cars:

Mileage	Reliability	Index
0 TO 20	1 TO 3	1
0 TO 20	4 TO 5	2
21 TO 50	1 TO 3	3
21 TO 50	4 TO 5	4

For COMPACT cars:

Mileage	Reliability	Index
0  TO 15	1 TO 3	1
0 TO 15	4 TO 5	2
16 TO 50	1 TO 3	3
16 TO 50	4 TO 5	4

For MID-SIZED cars:

Mileage	Reliability	Index
0 TO 12	1 TO 3	1
0 TO 12	4 TO 5	2
13 TO 50	1 TO 3	3
13 TO 50	4 TO 5	4

2. An Excel file named 'students' of the scores from the last semester for a statistics course is given. The following is a guideline for the overall final grade and the final exam score is out of 150 points, which means it should be recalculated to out of 100 points first. For example, if a student got 120 points on final exam, the actual score should be (120/150)*100=80 points.

Exam #1 (out of 100 points)	20%
Exam #2 (out of 100 points)	20%
Final Exam (out of 150 points)	30%
Quiz #1- Quiz #5 (out of 10, respectively)	15%
HW #1 - HW #2 (out of 50, respectively)	15%
Total	100%

Note that the final grade is assigned as follows: A for 90-100%; B for 80-89%; C for 70-79%; D for 60-69%; F for 59% or under.

(1) Report the average of homework and quiz scores (unit: percent) for each student.

(2) Report the total exam scores (= exam_1+exam_2+Final) for each student.

(3) Calculate the overall final score for each student.

(4) Create a new data set called 'grade_A' and print out the overall final score for A-Grade students only.

(5) Print the student identification number, the overall final score, and the final grade only.

3. Write a SAS program to give PDF (probability density function) and CDF (cumulative distribution function) of a binomial distribution with n = 10 and p = 0.1.

4. Write a SAS program to create a SAS dataset BIG which has 100 observations of X=INT(RANUNI(0)*100 +1). Print X values only from the dataset BIG.

Attachment:- Assignment Files.rar