Simple Corruption Pre-analysis (include ALL charts, graphs and tables you accomplish formatted to chic expectations). Assume all variables (with the barring of the accountable variable) are arrangement level.
YOU MUST HAVE the Data Assay Apparatus Backpack add-in installed to complete this assignment. Please assay the addendum for the anniversary apropos how to use the Corruption apparatus aural the Data Assay Apparatus Pack.
Open the dataset associated with this assignment. Use New Capital Expense as the allegorical capricious and End of Year Inventory as your acknowledgment variable
Accomplish a distinct Descriptive arbitrary table in Excel of the allegorical and acknowledgment variables. That is, accompanying access both variables into the Descriptive Statistic tool. Altercate the mean, median, accepted deviation, range, kurtosis, and skewness for EACH variable. Please DO NOT JUST LIST THE after summaries. Discussion involves estimation and should aftereffect in you autograph complete sentences. See the exemplar, column to Moodle, for a sample writeup.
Use Excel to account and the address the alternation cardinal for these two variables. Interpret the aftereffect of the alternation cardinal by discussing the beeline backbone and administration of the affiliation amid the two variables.
Use Excel to accomplish and address a besprinkle artifice for the 2 variables. The Allegorical capricious should be on the accumbent axis. Interpret the anatomy and administration of the plot. Format artifice to chic expectations.
Application alone the beheld assay of the besprinkle plot, is a transformation warranted? Please assay advance addendum and use what you apprehension about the dot arrangement aural the besprinkle artifice as affirmation to abutment your answer.
Use the Data Assay Apparatus backpack to run the corruption assay to accomplish a balance artifice for these variables. DO NOT INTERPRET NOR REPORT THE NUMERICAL SUMMARIES generated in the corruption tables. Copy and Paste ONLY the balance artifice into your report. Using alone the beheld assay of the balance plot, is a transformation warranted? Assay advance addendum and use what you apprehension about the dot arrangement aural the balance artifice to abutment your answer.
Check the 4 simple corruption assumptions. Advertence chic addendum so that you are bright what the checks should be and how to accomplish them in Excel. Create 4 subheadings to altercate EACH of the 4 assumptions advertence if the assumptions were met or were violated. Under anniversary subheading, additionally accommodate any tables or archive you’ve generated as affirmation for your conclusions. Format all archive and tables to chic expectations (see exemplar). Your claims apropos the assumptions charge be based on agreeable independent aural the tables, after summaries , or archive that you generated. Please advertence them by name in your address up. For instance “ It can be apparent in Figure 1 ….” Etc …
If any of the simple corruption assumptions were violated, attack to fix them application any aggregate of the 8 basal algebraic transformations (applied to either the allegorical or acknowledgment capricious or both) as presented in the addendum for this week. Discuss in detail which transformation access you absitively to booty and why. DO NOT SUBMIT the adapted dataset for grading. But, please address all archive or tables generated in Excel that you acclimated to abutment your transformation efforts.
Order a unique copy of this paper
Top Academic Writers Ready to Help
with Your Research Proposal