1. Assessing computer literacy: For purposes of assessing computer literacy , use theaccompanying data as

Final Version of Acct. 306 Assessment Project—Spring 20171. Assessing computer literacy: For purposes of assessing computer literacy , use theaccompanying data as directed below.Graphical analysis:a. Create a scatterplot of the observed number of units produced and the relatedmanufacturing overhead.b. Fit a regression line to the scatterplot.c. Display the equation of that line and also r-squared on the scatterplot.d. Simple regression: Use the Regression tool under the add-in “Data Analysis” ofExcel to generate a spreadsheet of output data with “UNITS PRODUCED” as theINDEPENDENT variable and “MANUFACTURING OVERHEAD” as theDEPENDENT variable.e. Multiple regression: Use the Regression tool to determine a regression equationusing the following two independent variables—(1) “units produced” and (2)“number of production batches” and using manufacturing overhead as theDEPENDENT variable.2. Assessing critical thinking: For purposes of assessing critical thinking, please answer thefollowing questions:a. What kind of relationship does the scatterplot show between the variables identifiedin 1(a)?b. Using the result of question 1(d), what is your estimate of manufacturing overhead if150 units were to be produced?c. How would you describe the quality of the relationship in part (a) based on the valueof r-squared?d. After doing 1(e), do you believe that adding a second independent variable, “numberof production batches” to the regression analysis improves the resulting regressionestimate compared to the result obtained using the simple regression equation thatyou computed by using just one independent variable, “number of units produced?”Explain the reason for your answer from the Regression tool output.e. DETERMINE THE FOLLOWING DATA: (1) average values for DM cost/unit andDL cost/unit and (2) the VARIABLE manufacturing overhead cost/unit and the totalFIXED manufacturing overhead cost from the SIMPLE regression analysis. Once youhave the data, calculate the BREAKEVEN POINT IN UNITS by inserting a formulainto a cell on your Excel spreadsheet.

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
The price is based on these factors:
Academic level
Number of pages
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more
error: Content is protected !!