skip to Main Content
The smarter way
to do assignments.

Please note that this is just a preview of a school assignment posted on our website by one of our clients. If you need assistance with this question too, please click on the Order button at the bottom of the page to get started.

Data Sheet “New Account Processing” – you can find this Excel file in Week 2.
Based on what you’ve learned in Chapter 3 and 4, calculate the following:
Total # of people: 125 (use this number)
Sample size: conduct a count via formula of the data in your spreadsheet
% of population: calculate the percentage of sample size from total number. Please note, if it is higher than 5%, you will need to calculate the correction factor.
Sample Mean of Sales: use formula
Sample Standard Deviation of Sales: use formula
Confidence Level: 95% (use this number)
Correction Factor: use the SQRT formula to calculate the correction factor
Standard Error: Sample StdDev divided by SQRT of sample size
Alpha: 5% (1 minus the confidence level)
Degrees of Freedom: Sample size minus 1
t-Value: TINV(Alpha, Degrees of Freedom)
Half-Width: T-value * Total # of people * Standard Error * Correction Factor
Lower Limit Total Sales: Total # of people * Sample Mean of sales minus Half-With
Upper Limit Total Sales: Same as above, except you add the Half-With
Please complete all calculations in the Excel file provided to you. I have provided hints and numbers to help you complete this assignment. Please do not change the values I provided in the instructions. 
Save your file with your Firstname_lastname and submit in the designated area. I will need to see the formulas, so make sure you use them! In a short paragraph, within the spreadsheet, explain why this analysis might be important to a business owner. What does the data tell you? Please be mindful of the submission deadline as there is no allowance for late submissions.


Clicking on this button will take you to our custom assignment page. Here you can fill out all the additional details for this particular paper (grading rubric, academic style, number of sources etc), after which your paper will get assigned to a course-specific writer. If you have any issues/concerns, please don't hesitate to contact our live support team or email us right away.

How It Works        |        About Us       |       Contact Us

© 2018 | Intelli Essays Homework Service®

Back To Top