# STATISTICAL ANALYSIS TO SUPPORT DECISION MAKING

STAT1060 – Assignment 2 Semester 2, 2020
STATISTICAL ANALYSIS TO SUPPORT DECISION MAKING
Total marks: 46, Weight: 20%
Due: November 8, 23.59 PM (Sunday of Week 12)
Submission instructions and general marking criteria
• Submit a copy in Word or PDF format via Turnitin.
• Assignments submitted by other means (e.g. email) or forms (scanned copy, Excel document) will attract no marks.
• Late Submission Penalty: As detailed in the Course Outline.
• It is expected that Excel is used to assist with calculations and preparation of appropriate graphs. All relevant Excel output should be included with your assignment. However, raw computer output without explanatory text is not acceptable. Answers must be written in clear English sentences clearly linked to appropriate supporting computer output. Only extract the parts of the Excel output that are relevant toansweringthe question should be includedandoutput not relevant should not be included.
• You will need to demonstrate understanding of types of data, the use of graphs to explore distributions of variables and relationships between variables, and of statistical tests of such relationships. Marks will be awarded based on the quality of your assessment of the data and how clearly that assessment is communicated.
• The assessment requires you to apply concepts from Weeks 5 to 10 to a specific scenario and to apply the correct analysis to the various scenarios/data sets and to write up the results of a statistical analysis.
Question 1 (6 Marks)
Car buyers in the city of Newcastle were asked by a car dealer to rate their level of satisfaction with the service that they received. The four possible ratings were: Excellent (E), Good (G), Satisfactory (S) and Unsatisfactory (U). Data showing the level of satisfaction with the service for December 2019, is provided in the file Question1.xlsx.Column A contains the level of satisfaction scores.
(i) What type of variable is “level of satisfaction” (Continuous, Discrete, Ordinal or Nominal)? Be sure to justify your answer. [2 Marks]
(ii) Name the appropriate graphical display to use to display ‘level of satisfaction’, based on the variable type you identified in part (i). [1 Mark]
(iii) Use Excel to create the appropriate graph to display the provided data. [1 Mark]
(iv) Comment on the key aspects from this graph. [2 Marks]
Question 2 (4 Marks)
Commuting times of students who travel by bus to the University of Newcastle Callaghan campus are known to be normally distributed with a mean of 25 minutes and standard deviation 5 minutes. Use the empirical rule of the normal distribution to answer the following questions. Shade in (roughly) the corresponding area under the curve for each part (i-iv).
(i) What is the probability that the student’s commuting time is less than 20 minutes to reach campus? [1 Mark]
(ii) What is the probability that the student’s commuting time is more than 35 minutes to reach campus? [1 Mark]
(iii) What is the probability that the student’s commuting time is between 15 and 30 minutes to reach campus? [1 Mark]
(iv) Find the bus commuting time that corresponds to the 97.5 % percentile (approximately) of the distribution (i.e. find the commuting time above which only 2.5% of the distribution appears). [1 Mark]

Variance 7.7202 0
Observations 100 2
Hypothesized Mean Difference 0
df 99
t Stat 4.7618
P(T =t) one-tail 0.0000
t Critical one-tail 1.6604
P(T =t) two-tail 0.0001
t Critical two-tail 1.9842
Question 4 (14 Marks)
The University of Newcastle marketing services are interested in mobile usage technology. A study was undertaken in which a random sample of students enrolled at the University of Newcastle in 2019 and 2020 were invited to participate in a project about the daily usage of smartphones. There were 50 randomly selected students in 2019 and 50 randomly selected students in 2020 who participated in the study. Data is provided in the Excel file Question4.xlsx. Columns A contains student smartphone daily usage in 2019 and Column B contains student smartphone daily usage in 2020 (minutes per day).
(i) Use Excel to construct a histogram of studentsmartphone daily usage in 2019. How would you describe the distribution, including the shape? Include a histogram with your response.
[2 Marks]
(ii) Use Excel to construct a histogram of studentsmartphone daily usage in 2020. How would you describe the shape? Include a histogram with your response. [2 Marks]
(iii) Use Excel to find the mean, median, standard deviation and interquartile ranges of student smartphone daily usage in 2019. Repeat for the smartphone daily usage in 2020. [2 Marks]
(iv) Using the information from parts (i)-(iii), give a brief statement comparing smartphone daily
usage in 2019 with smartphone daily usage in 2020. [2 marks]
(v) Explain, using support from a hypothesis test, if the average smartphone daily usage in 2019 differs from the average smartphone daily usage in 2020. Perform the hypothesis test at the 5% significance level. Assume that data in 2019 and 2020 were taken from different students.
? the null and alternative hypotheses
? the p-value
? conclusion
(Hint): Research Question: Was the average smartphone usage the same in 2019 and 2020?
[6 Marks]
Question 5 (6 Marks)
A JB Hi-Fi franchise in Newcastle set a discount pricing strategy with the aim to increase the sales of smartphones. The difference* (with promotion and without promotion) in sales of new smartphone is defined as:
Difference* = Sales on days with promotion – Sales on matched days without promotion
Test the hypothesis of whether there is a difference, at the 5% significance level, between the mean difference in sales of new smartphones (between days with promotion and days without promotion). Comment on the result. Use Figure 2 to answer the research question. Note: Both sets of days’ measurements were taken from the same JB
Hi-Fi franchise.
Figure 2: t-Test: Two-Sample Assuming Unequal Variances

Difference Dummy

Mean 14.4873 0
Variance 102.1922 0
Observations 50 2
Hypothesized Mean Difference 0
df 49
t Stat 10.1336
P(T =t) one-tail 0.0000
t Critical one-tail 1.6766
P(T =t) two-tail 0.0001
t Critical two-tail 2.0096
Question 6 (10 Marks)
A sample of 450 students was selected from the University of Newcastle to determine if there is a relationship between smoking status and student’s diet (Vegetarian and non-Vegetarian). Use Figure 3 to answer the following probability questions (i) – (iv).
Figure 3: Observed Frequencies
Vegetarian Non-vegetarian Total
Smoker 18 25 43
Non-smoker 97 310
115 335
(i) What is the probability that a randomly selected student is vegetarian? [1 Mark]
(ii) What is the probability of a randomly selected student being “Vegetarian and a Non-smoker”? [1 Mark]
(iii) What is the probability of a student being “Vegetarian or a Smoker”? [1 Mark]
(iv) What is the probability that a randomly selected student is a Non-smoker given that the student is
Non-vegetarian? [1 Mark]

Figure 4: Multiple bar chart for Smoking status and Diet of students
Figure 5: Expected Frequencies
Vegetarian Non-vegetarian Total
Smoker 10.99 32.01 43
Non-smoker 104.01 ***
115 335
(v) In Figure 5, calculate the expected count for the empty cell corresponding to the Non-vegetarians who are non-smokers. Note that this cell corresponds to the observed count of 310 in Figure 3. [1 Mark]
(vi) Conduct an appropriate hypothesis test at the 5% significance level to determine if there is a statistically significant relationship between Smoking status and student’s Diet. Be sure to report at least the P-value and use this to answer the research question. The p-value for the test statistic is given as 0.010.
[5 Marks]

The post STATISTICAL ANALYSIS TO SUPPORT DECISION MAKING appeared first on Versed Writers.

Pages (550 words)
Approximate price: -

Quality Research Papers

We always make sure that our academic writers follow all your instructions precisely. You can choose your academic level and we will assign a writer who has a respective degree.

We have a team of professional writers with experience in academic and business writing. Many are native speakers and able to perform any task for which you need help.

Unlimited Revisions

If you think we missed something, send your order for a free revision. You have 10 days to submit the order for review after you have received the final document.

On time Delivery

All papers are always delivered on time. In case we need more time to master your paper, we may contact you regarding the deadline extension. Otherwise a 100% refund is guaranteed.

Original & Confidential

We use several writing tools checks to ensure that all documents you receive are free from plagiarism. We also promise maximum confidentiality in all of our services.

Our support agents are available 24 hours a day 7 days a week and committed to providing you with the best customer experience. Get in touch whenever you need any assistance.

Try it now!

## Calculate the price of your order

Total price:
\$0.00

How it works?

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Whether you have an urgent deadline or those that have time. You can take some time and relax after trusting us with your paper. We make sure that we conduct the academic writing services diligently.

## Essay Writing Service

Among the wide variety of academic work, essay writing is one of the simplest a student can ever come across. Usually, it is a task which students encounter and learn how to write whilst in high school. However, the case is quite different when it comes to university and college.

Term Paper Writing

Are you looking for an online writing firm that can offer you reliable custom term paper writing help? Is your wish and desire to get someone who can guide you throughout the process of writing term papers? If yes, then you have come to the right place.

Coursework Writing Help

Coursework is essential for every student in order to graduate from college. However, most of it is deadline-centric, and that becomes a challenge to most learners. With the amount of work, learners are receiving every day, finding time to work on every task is not easy.

Online Homework Help

Online homework help services are an answer to every challenge that students go through. Despite the difference in the needs and levels of learning, all students can benefit from these services. Acemyhomework is one of the best online homework help service companies you can find on the internet.