Unformatted text preview:

Business Mathematics IHomework 6Solution.Solution.Business Mathematics IHomework 6Prepared forStephen ReyesMath 115a, Section University of Arizona ByTeam #Submitted onDateWe, the undersigned, affirm that all of us participated fully and equally in the completion of this assignment and that the work contained herein is original. Furthermore, we understand that sanctions will be imposed individually as well as jointly if any part of this work is found to violate the Student Code of Conduct, the Code of Academic Integrity, or the policies and procedures established for this course. ______________________________ ______________________________Name (typed) Signature______________________________ ______________________________Name (typed) Signature______________________________ ______________________________Name (typed) Signature______________________________ ______________________________Name (typed) Signature______________________________ ______________________________Name (typed) Signature1. (Exercises 4 & 5 from Histograms) A small business has kept records of the number of sales per day and the gross daily sales for a period of 4 years. Since they are open 5 days a week, except for two holiday weeks, they have records of 1,000 business days. These are shown in the sheet Raw Data of the Excel file Daily Sales.xls. (i) Open that file, and sort the data by “Day of Week.” (ii) After sorting, use Copy and Paste to copy the records of the 200 Mondays into the sheet Monday of Daily Sales.xls. Repeat this process for the records from (iii) Tuesdays, (iv) Wednesdays, (v) Thursdays, and (vi) Fridays.Solution. 2. (Exercises 10 & 11 from Histograms) (i) Compute the minimum, maximum, average, and range of gross sales for the records that were copied into the sheet Monday of Daily Sales.xls in Problem 1. Repeat for the (ii) Tuesday, (iii) Wednesday, (iv) Thursday, and (v) Friday data in Daily Sales.xls. (vi) Which day had the largest average gross sales? (vii) Which day had the smallest average gross sales?Solution. 3. (Exercise 15 from Histograms) (i) Compute the set of times between arrivals and times until the first arrival for your team’s first hour. (ii) Calculate the minimum, mean, maximum, and range for these times.Solution. 4. (Exercise 16 from Histograms) Redo Parts (i) and (ii) of Problem 3, using your team’s data for its second hour.Solution. 5. (Exercise 18 from Histograms) Referring to the Monday data from Daily Sales.xls, which was discussed in Problem 2, create a histogram plot of the gross sales.Solution. 6. (Exercise 21 from Histograms) Consider the set of times between arrivals and times until thefirst arrival for your team’s first hour. Plot a histogram of the relative frequencies for these times using suitable bins. Solution.7. (Exercise 22 from Histograms) Redo Problem 6, using your team’s data for its second hour.Solution. 8. (Exercise 23 from Histograms) (i) Calculate the minimum, mean, maximum, and range for the ATM service times in your team’s data. (ii) Plot a histogram of the relative frequencies ofthese service times in suitable bins. (iii) Use your computations in Problems 6 and 7, and Part (i) of this exercise to draw preliminary conclusions about the numbers of ATM’s that would need to be opened at each of your team’s usage


View Full Document

UA MATH 115A - Homework

Documents in this Course
Bus MathI

Bus MathI

28 pages

Options

Options

23 pages

Load more
Download Homework
Our administrator received your request to download this document. We will send you the file to your email shortly.
Loading Unlocking...
Login

Join to view Homework and access 3M+ class-specific study document.

or
We will never post anything without your permission.
Don't have an account?
Sign Up

Join to view Homework 2 2 and access 3M+ class-specific study document.

or

By creating an account you agree to our Privacy Policy and Terms Of Use

Already a member?