PART A: Suppose that the mean download time for a commercial tax preparation site is 2.0 seconds. Suppose that the download time is normally distributed, with a standard deviation of 0.5 second. What is the probability that a download time is:
above 1.8 seconds?
between 1.5 and 2.5 seconds?
99% of the download times are slower (a higher number of seconds taken to download) than how many seconds?
PART B: The file Utility contains the electricity costs, in dollars, during July 2010 for a random sample of 50 one-bedroom apartments in a large city. Decide whether the data appear to be approximately normally distributed.
Decide whether the data appear to be approximately normally distributed by:
(a) Constructing a box plot.
(b) Constructing a histogram.
(c) Comparing data characteristics to theoretical properties.
(d) Constructing a Quantile-Quantile Normal Probability Plot.
You must include all Excel results for this data as part of the justification for your conclusions. (Include them within the appropriate section – not at the end of your document.)
Your assignment must be submitted as a single word document via LMS. You will find the data in Utility in LMS under Topic 5, Data Files.1 Based on Question 6.22 in Levine et al (2013)
Further comments:
Your completed assignment needs to include the following components:
PART A: Completed questions. PART B:
An Introduction, where the key aspects of this topic are fully discussed. (This discussion should be referenced using the Chicago referencing method)
The Body of your assignment, where all of your findings are presented. (This should include relevant Excel results, graphs, tables…) Each of the pieces of information that are included need to be discussed in relation to the given question.
A Conclusion, which summarises your key findings and links these back to your comments in the introduction.
A Bibliography which includes all resources referenced within your assignment.
INCLUDE THE MARKING GUIDE (BELOW) AT THE END OF YOUR ASSIGNMENT.
Marks will be allocated according to the quality of each of the components above. It is important that you present your assignment with sufficient detail to fully answer the given question, while at the same time present your arguments in a concise way. (As a guide: Word Limit, at least 1500 words).
IMPORTANT NOTE: Remember that this is an individual assignment. You must write the discussion sections of the assignment yourself and in your own words. Do NOT simply replace words from another student’s work with similar words. All assignments which include plagiarism of any form will be officially reported for further investigation.
NAME:
PART A MARK AND COMMENT
PART B (a) MARK AND COMMENT (b) MARK AND COMMENT(c) MARK AND COMMENT(d) MARK AND COMMENT
(a)
/2
(b)
/3
(c)
/3
Box Plot:
-Plot, Title, Label
/2
- Five Number Summary
/1
Summary Comments on Box plot
/2
Histogram:
-Title
-Label
/2
-No gaps
-Corrected bin values
/2
-Suitable bin size
/1
Summary Comments on Histogram
/2
Theoretical Properties:
Included Summary Stats
/2
Compared Mean and Median
/1
IQR ~ 1.33 times the std dev
/1
Range ~ 6 times std dev
/1
68.26% values lie +/- 1 std dev of mean
/1
80% values lie +/- 1.28 std dev of mean
/1
95.44% values lie +/- 2 std dev of mean
/1
Skewness zero
/1
Kurtosis zero
/1
Summary Comments on Theoretical Properties
/2
Normal Probability Plot
/2
Table of Values:
- Ordered X
- Ordered Probability
- Ordered Z
/3
Summary Comments on Normal Probability Plot
/2
INTRODUCTION
CONCLUSION
BIBLIOGRAPHY
/3
/3
/1
BONUS POINTS:
TOTAL:
/46