BUSN 250 Week 4 Assignment | American Public University System
- american-public-university-system / BUSN 250
- 27 Dec 2022
- Price: $8
- Management Assignment Help / Business Management Assignment Help
BUSN 250 Week 4 Assignment | American Public University System
Week
4 Assignment
Instructions
Week 4
Homework
Chapter 4
Using
the data files provided for Chapter 4, Work the assigned problems in your
text Business Analytics: Methods, Models, and Decisions 2nd edition USA:
|
Chapter 4 |
|
4.1, page 127 |
|
4.2, page 127 |
|
4.3, page 127 |
|
4.4, page 127 |
Attached
are also the required problems, along with Home Work Template. Data sets
required are attached as well.
4.1
Data obtained from a county auditor in the Excel file Home Market Value provide
information about the age, square footage, and current market value of houses
along one street in a particular subdivision. Considering these data as a
population of homeowners on this street, compute the mean, variance, and
standard deviation for each of these variables using a spreadsheet and formulas
(4.1), (4.4), and (4.6). Verify your calculations using the appropriate Excel
function.
4.2
In the Excel file Facebook Survey, find the average and median hours
online/week and number of friends in the sample using the appropriate Excel
functions. Compute the mode and compare all measures of location.
4.3
For the Excel file Tablet Computer Sales, find the average number, standard
deviation, and interquartile range of units sold per week. Show that
Chebyshev's theorem holds for the data and determine how accurate the empirical
rules are.
4.4
The Excel file Atlanta Airline Data provides arrival and taxi-in time
statistics for one day at Atlanta Hartsfield International airport. Find the
average and standard deviation of the difference between the scheduled and
actual arrival times and the taxi-in time to the gate. Compute the z-scores for
each of these variables.
Please
set each problem up on its own tab within the workbook. Be sure you have
organized your work and it is easy to read. Save your file as LastName-Wk4.xls
Once
you have finished the problem sets, upload your completed workbooks for
grading. Please note, if you do not submit your work by the due date or the
late date, you will automatically get a -0- on the assignment.
USA 
India