Analysis of Vehicle Weight by Origin

I’m stuck on a Statistics question and need an explanation.

  • Our organization, Trucking Inc, has recently entered contract negotiations with three separate automotive distribution companies. We must sign an exclusive long-term deal to haul sedans from a port city to various destinations.The weight of the Sedans by the origin may influence the number of vehicles that we may haul per trip as well as the fuel required. Our research question is: “Is there a statistically significant difference in the weight of sedans based on their origin?” We will examine the data using a one-way ANOVA with an α of .05.Our statistical question is:
    • Null hypothesis – HO: µAsia = µEurope = µUSA
    • Alternative hypothesis – HA:Not all means are equal.
  • This paragraph describes where the data came from, the steps that you took to explore the data and if the data is appropriate for the model.Where is the data from?How did you filter the data?How many resulting records are there in total and by category (Table 1)?Are there enough records in each category and are they approximately the same number?Were there missing data points?Were there outliers?What did you do with any outliers and why (Figure 1)?Were there issues with normality (Skewness and kurtosis + visual analysis of Figure 1 and 2).Was the assumption of Homogeneity of Variance met (Note if the test is significant then the assumption is not met).
  • This paragraph discusses the results.Were the model results significant (Use ANOVA Results if Homogeneity of Variance is met and Welches ANOVA if it is not.Report the f value and the p value from SAS and supply the ANOVA table from Excel as Table 2)? What was the R-Square and what does it imply?Which Origins were significantly different from each other (Table 3 Least Squares Means for effect Origin)?Examine the differences in the means do the significant differences seem like they are significant if you are hauling up to 12 cars per trip?
  • What is your recommendation for the contract?Is further analysis needed?Creatively quantify the impact of your recommendation if your results are meaningful and significant (Number of cars change?Fuel efficiency change?).

Minimum tables are figures include the Summary Table,ANOVA from Excel, Least Squares Means For Effect Table from SAS, and Box Plots from SAS.

Questions I provided in the Memo, all the data required for the question I have given 3 files in the attachment

This criterion is linked to a Learning OutcomeBusiness Memo Submitted on time.-10 for every day late.

10.0 pts

Full Marks

0.0 pts

No Marks

10.0 pts

This criterion is linked to a Learning OutcomeCorrect Salutation, date, subject line.

5.0 pts

Full Marks

0.0 pts

No Marks

5.0 pts

This criterion is linked to a Learning OutcomeParagraph 2Discuss the steps that were taken to prepare the data, explore the data, and test model assumptions. Refer to the summary table as well as figures.

20.0 pts

Full Marks

15.0 pts

Mostly Correct

10.0 pts

Somewhat Correct

5.0 pts

Mostly Incorrect

0.0 pts

No Marks

20.0 pts

This criterion is linked to a Learning OutcomeParagraph 3Discuss the results of the ANOVA. You should list all relevant F and P-values and reference relevant tables. You should discuss the R Square. Are any significant findings meaningful?

20.0 pts

Full Marks

15.0 pts

Mostly Correct

10.0 pts

Somewhat Correct

5.0 pts

Mostly Incorrect

0.0 pts

No Marks

20.0 pts

This criterion is linked to a Learning OutcomeParagraph 4Provide a meaningful recommendation. You should discuss why you made this recommendation and quantify the value.

20.0 pts

Full Marks

15.0 pts

Mostly Correct

10.0 pts

Somewhat Correct

5.0 pts

Mostly Incorrect

0.0 pts

No Marks

20.0 pts

This criterion is linked to a Learning OutcomeTables and FiguresYou should provide the summary table, boxplots, ANOVA table from Excel, Least Squares Means Difference by Origin From SAS as well as any other figures you feel will aid your writing.

[opskill_register_order]

"Looking for a Similar Assignment? Order now and Get a Discount!

Open chat
Need a Paper Done?
essaywritinghelp.net
Hello
Can we help you?