The subject header must be E3060 – PROJECT – LAST NAME, FIRST NAME. You will use
Place your order now for a similar assignment and have exceptional work written by our team of experts, At affordable rates
For This or a Similar Paper Click To Order Now
The subject header must be E3060 – PROJECT – LAST NAME, FIRST NAME.
You will use Excel to perform various statistical functions that are stated in the Grading Rubric & Project Questions section below.
Using Word, you will answer the 12 questions found in the Grading Rubric & Project Questions section below.
Convert your Word document into a PDF and upload the file via Canvas.
MATERIALS REQUIRED & ALLOWED
Microsoft Word
Microsoft Excel
Calculators
HELPFUL EXCEL FORMULAE
COMMON EXCEL FORMULA
=AVERAGE()
=MEDIAN()
=STDEV.S() – Std Dev for a sample
=STDEV.P() – Std Dev for a population
=VAR.S() – variance for a sample
=VAR.P() – variance for a population
Grading Rubric & Project Questions
Grading Rubric for Project (in Points)Questions (50 Points Possible)Full CreditPartial Credit (Incorrect Answers)Partial Credit (Incomplete Work)No Credit
1How many data points are in your final analysis?10.750.250
2What is the average, median, variance and standard deviation of each variable7420
3Graph each variable using a bar chart.5310
4Is there any skewness in the data? Which direction?21.50.50
5What is the cause of the skewness?5310
6Which wines are possible outliers and why?5310
7Create scatter plots between the dependent and each independent variable.
Produce the R2 value for each scatterplot.
Produce the correlation values for each scatterplot.
Which scatterplot shows the strongest and weakest relationship?
3
2
2
3
1.5
0.75
0.75
1.5
0.75
0.25
0.25
0.75
0
0
0
0
8Determine the multiple regression formula using all independent variables. Show the ANOVA table.
1
0.75
0.25
0
9What is the coefficient of determination, and adjusted coefficient of determination? What do these values illustrate?
3
2
1
0
10At what point/value is each independent variable significant? What does a 1 unit increase in each independent variable do to the dependent variable?
4
3
1
0
11What is the mean squared error for this model? What does it mean?
3
1.5
0.5
0
12Using 1% & 5% alphas, test the overall significance of the model.
4
2
1
0
