Q1
The data for this (and all other) assignment is located on blackboard. You should save a copy to a flat ASCII (space delimited) file and a formatted ASCII (comma delimited) file. This gives you three copies of the data.
You are to use the IMPORT command to read EACH of the three datasets into SAS. Confirm that the data are correct.
You are to write a DATA step that correctly reads the two ASCII files into a SAS dataset.
Q2
You are to create dummy variables for each month and each day of the week. Make sure that these are functioning properly. Also create a log variable for the two temperature variables.
Create a deviation from mean for the temperature variables.
Create squared terms for each of the temperature variables in deviation from mean form.
You are to get the summary statistics from the dataset and save the output file as a .lst file. Send me both the .sas and the .lst files.
Q3
Do a regression of sales on all of the relevant variables using the linear versions of the temperatures. Be sure to remove any variables that create multicolinearity.
Do the same regression as in 1) above but using the log versions of the temperatures.
Do the same regressions as in 1) and 2) above but in each case do a separate regression for each month of the year.
Q4
You are to take the linear regression from Q3 and perform the following tests.
Test each coe¢cient against the null hypothesis that it is 0.
Examine the coe¢cient for rain and test the null hypothesis that it is -1500.
Examine the coe¢cient for Temperature and test the null hypothesis that it is 38.
Examine the coe¢cient for Min Temperature and test the null hypothesis that it is 20.
Examine the coe¢cient for Holiday and test the null hypothesis that it is less than 2000.
You are to turn in the SAS program and a short WORD document that describes the results completely. Also, include a complete description of the regression from Q3.
Q5
1. Carry out a White test test for heteroskedasticity.
2. Carry out a Durbin-Watson test for serial correlation.
3. Test your data for multi-colinearity in both fashions that you know how to do this test.
You are to turn in the SAS program and a short WORD document that describes the results of your tests.
Q6
Test the null hypothesis that day of week is not important for predicting sales.
Test the null hypothesis that month of year is not important for predicting sales.
Test the null hypothesis that the squared temperature variables are not important for predicting sales.
You are to turn in the SAS program and a short WORD document that describes the results of your tests.
Are you looking for a similar paper or any other quality academic essay? Then look no further. Our research paper writing service is what you require. Our team of experienced writers is on standby to deliver to you an original paper as per your specified instructions with zero plagiarism guaranteed. This is the perfect way you can prepare your own unique academic paper and score the grades you deserve.
Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.
[order_calculator]