Create a new folder named final in your computer

Assignment Help Applied Statistics

Reference no: EM131596214

Assignment

Problem 1. Refer to Table 1 to complete the following questions.

Name	Class	Homework	Midterm1	Midterm2	Project
Justin	1	.	88	90	82
Christal	1	100	85	80	88
Rebecca	1	80	77	.	65
Easton	2	90	.	76	73
Jacob	2	60	67	53	70
Cindy	2	85	83	66	90

Table 1: Grades

1. Create a new folder named Final in your computer. Specify a library reference name for this library and read the dataset in Table 1 into the library.

2. Create a new variable Avgmid, which is the average of the two midterms. If one of the two midterms is a missing value, I expect the average to be the grade of non-missing one. For example, if John misses midterm1 and his grade for midterm2 is 90, then Avgmid for John should be 90. And then calculate the final score (denoted by the variable Final ) according to the following rule:

Final = 30%Homework + 40%Avgmid + 30%Project If Homework is a missing value, then the final score is defined to be

Final = 50%Avgmid + 50%Project

3. Use Means Procedure to generate a summary dataset, which should includes the mean, median and standard deviation for the final score of students in Class 1, students in Class 2 and all of the students.

4. Use Report Procedure to generate a report for the summary dataset, use Define State- ment to define labels for the variables.

5. From the report you generated, what are the mean, median and standard deviation for the final score of students in Class 1, students in Class 2 and all of the students? Please write answers in the comments of your .sas file.

Problem 2. We have the following small dataset.

Item	Shop	Year	Date	Price
Cellphone	A	2013	02/25/2013	$259.99
Vacuum Cleaner	W	2014	09/30/2014	$78.29
Toaster	A	2014	07/12/2014	$32.35
Microwave	E	2013	12/05/2013	$87.40
Headphone	E	2014	01/03/2014	$96.72
Monitor	A	2013	03/21/2013	$275.99
Clothes Iron	W	2013	10/04/2013	$39.73

Table 2: Shopping List

The columns, from left to right, represent the following variables (see Table 3):

Variable Name	Description	Variable Type
Item	Item name	Character
Shop	Code for shop	Character
Year	Year when bought	Numeric
Date	Date when bought	Numeric
Price	Price of the item	Numeric

Table 3: Description

1. Use proper method to read the dataset in Table 2 into the library and generate two reports using Report Procedure and one two-way frequency table using Freq Procedure. I want you to create reports and table looking similar to Figure 1. (See next page)

Pay attention to:

(a) the group of items, ( hint: the items are grouped by Shop and Year ); (b)the label of variables;

(d) the title;

(e) there is one variable with label "Number of Items" in the summary report.

2. What is the meaning of the four numbers in the cell Amazon× 2014? Please write answers in the comments in your .sas file.

Attachment:- Assignment.pdf

Reference no: EM131596214

Questions Cloud

Actions on equilibrium income : 1. Explain the effects of the following actions on equilibrium income. a. Government purchases rise by $40 billion.

Discuss the use of rogerian person-centered approach : Summarize the use of Rogerian's person-centered approach to reality therapy for a multicultural population.

Distinguishing characteristics that made individual victim : In this week's reading, we examined the "vulnerable populations" (Hickey, 2013). Using FOUR external references, compare and contrast male and female offenders.

Pricing in a managerial environment : 1. Discuss the issues and difficulties associated with pricing in a managerial environment.

Create a new folder named final in your computer : Create a new folder named Final in your computer. Specify a library reference name for this library and read the dataset in Table 1 into the library.

What should walkskyer pay if market rates : Luke Walkskyer wants to buy your mortgage. What should Walkskyer pay if market rates are 11%?

United states progress in the future : How should labor relations in the United States progress in the future? What should the future of labor unions look like?

Difference in the equivalent uniform annual cost : what is the difference in the equivalent uniform annual cost (EUAC) of buying Machine B compared to continuing to use Machine A:

Dissemination of ebp project results : Describe one internal and one external method for the dissemination of your EBP project results.

User Account

All Pages