# In your report, use the results that you calculated from the Excel spreadsheet. But don’t just transfer the numbers from Excel into Word write a proper report. Interpret and discuss what the numbers mean in sentences and paragraphs as you’d do in a workplace report

Instructions
1. Answer the three (3) questions in the form of a workplace report, containing brief, easy-to-read paragraphs
2. Use the MS Excel data in Moodle Assessments Assessment 2: Individual report Excel data
3. Find Question 1’s data in the spreadsheet labelled ‘Q1’, Question 2’s data in ‘Q2’, and so on
4. Write your report in MS Word (1,000 word or less— length is not an issue, but explain findings satisfactorily) 5. In your report, use the results that you calculated from the Excel spreadsheet. But don’t just transfer the numbers from Excel into Word; write a proper report. Interpret and discuss what the numbers mean in sentences and paragraphs as you’d do in a workplace report (see sample report below).
7. Submit it in Moodle Assessments Assessment 2: Individual report ‘Turnitin submission: [lecturer name]’ 8. Due by 11:59 pm, Sunday, Week 9 (if you forget this time, day and week, do not go to step 9)
9. Celebrate with a tasty drink.
Report format
1. Round all final answers to two decimal places (t = 3.0823165563 ? t = 3.01)
2. Make your report look good. Out of the 35% awarded for this assessment, 5% is given for how neat, articulate and professional your report looks. See sample report to learn how to structure this report.
2. Font: Your choice ? Font size: 12 ? Line spacing: single or 1.5 ? Insert page numbers + space between paragraphs
3. Attach electronic student declaration form at the front. Give report a title inside. Divide report into sections:
1. Introduction
2. Chi-squared test
3. Hypothesis testing I 4. Hypothesis testing II
5. Conclusion (summarise findings)

Question 1: Week 4 | chi-squared test | 10 marks
When you write this section, remember to:
(a) State the null (Ho) and alternative (Ha) hypotheses
(b) Show all observed (O) and expected (E) values (copy and paste as a screenshot)
(c) Show all the X2 values (copy and paste as a screenshot)
(d) Assess the total and critical X2 values (as sentences in a paragraph): based on their values, will you keep the Ho or reject it and go for Ha? Why?
(e) Interpret (as sentences in a paragraph): comparing the O and E values, and referring to the X2 values, what pattern do you see if there is a relationship? What business advice would you provide?
Question 2: Week 7, hypothesis testing I (for one sample) | 10 marks
When you write this section, remember to:
(a) State the null (Ho) and alternative (Ha) hypotheses. Explain briefly what they mean.
(b) Does it involve a one-tailed test or a two-tailed test? Why do you say that?
(c) What is your calculated t-score? What is the critical t-score?
(d) Assess the calculated and critical t-scores (as sentences in a paragraph): based on their values, will you keep the Ho or reject it and go for Ha?
(e) Interpret: what does your chosen hypothesis says (the findings)? Next, what business advice would you provide?
Question 3: Week 8, hypothesis testing II (for two samples) | 10 marks
When you write this section, remember to:
(f) State the null (Ho) and alternative (Ha) hypotheses. Explain briefly what they mean.
(g) Does it involve a one-tailed test or a two-tailed test? Why do you say that?
(h) Did you use an independent samples test or a paired samples test? Why?
(i) Copy and paste a screenshot of your Data Analysis output. What is your calculated t-score? What is the critical t-score?
(j) Assess the calculated and critical t-scores (as sentences in a paragraph): based on their values, will you keep the Ho or reject it and go for Ha? Interpret what your chosen hypothesis says (the findings). Finally, what business advice would you provide?
? 30 marks for correct answers for each question
? 5 marks for how well you wrote the report: was it brief and direct, laid out professionally, easy-to-read and explains what the data and calculations say?
? 35 marks, or 35% overall
Where does that fit in? Overview of marks (with some examples of marks and grades you could get)
Assessment Max. marks You: “What did I get?”
Online Quiz 1 20 marks E.g. 11 (55%? P)
Individual report 35 marks E.g. 29 (83% ? D)
Group presentation 25 marks E.g. 20 (80%? D)
Online Quiz 2 20 marks E.g. 15 (75%? D)
Total 100 marks (100%) E.g. 75% (D)*
*What this shows is that HDs or Ds are possible even if you got a pass or fail for Online Quiz 1. So do your best.
Sample report (the cases used here might be different from the ones in your actual questions)
Data-informed decisionmaking for Starducks Café by Kanye East
This report discusses the findings from data that was collected for three different situations for our company, and how these findings might improve our company’s performance.
The first case is about _______________________________… . Here, I will use [what technique or test?].
The second one concerns _______________________________… . Here, I will use [what technique or test? And so on].
2. Analysing whether high-spending customers tend to sit outdoors or not: chi-squared test
Should all our cafes move towards having more outdoor seating than indoors? Could it be more profitable? To analyse this at our Starducks Cafés, we sampled n = _______ customers during the period ____________ .
The hypotheses of our investigation are:
Null hypothesis (Ho): ____________________________
Alternative hypothesis (Ha): ______________________
In Tables 2 to 4 are our observed, expected and chi-squared values.
Tables 2 to 4: Observed, expected and chi-squared values for ________________________
From here we can see that the total _____________________________________________…
Since we reject the Ho and thus accept the Ha, this means that _____________________________ …
Looking at the O and E values closely, it shows us that _____________ … . What this might mean for the business is that ___________________ .
3. Are our customers’ ratings significantly higher than normally presumed? Hypothesis testing I
We’ve known that customer ratings of our service quality have been on average 7.2 out of 10 in the last several years. However, has the new training we introduced at the end of last year worked to significantly increase customer rating?
I did an investigation that involves a ____ -tailed test. Therefore, the Ho and Ha are:
Ho: µ = 7.2 points
Ha: µ 7.2 points
What these hypotheses are saying is that _________________________________________… To investigate this, I sampled _________________________________________________ …
The sample average and standard deviations are ___________________________________ …
The critical t-score is _____________ whereas, based on the following calculations, the calculated tscore is _______________________ …
Comparing the critical and calculated t-scores shown above, I do not reject the Ho because _________________… Therefore I conclude that as a business, we should _______________________ .
4. Does hiring more international workers significantly improve sales? Hypothesis testing II
The investigation here is to find out whether, at Starducks Café, hiring more international workers compared to domestic staff significantly boosted our sales beyond the average we normally get.
To investigate if this is true in general, I sampled two types of Starducks branches: A with mostly international workers, and B with mostly domestic workers.
I obtained data for n = 30 weeks at the A branches, and obtained data for n = 32 weeks at B branches _____________________ … [keep going].
This is a ____ -tailed test. Therefore, the Ho and Ha are:
Ho: µA, international = µB, international
Ha: µA, international µB, international
What these hypotheses are saying is that ________________________ …
[Keep going]…
Given the critical and calculated t-scores shown above, I found that the Ho _________________… Therefore I conclude that as a business, we should _______________________ .
5. Conclusion
My analyses show that the strategies we should take as a business are:
• When it comes to ____________________, we should ________________________ …
• ____________________________________________________________________ …
• ____________________________________________________________________ …
Some further ideas I propose are _______________________________________________ .
by: Hemanath Swarna

The post In your report, use the results that you calculated from the Excel spreadsheet. But don’t just transfer the numbers from Excel into Word; write a proper report. Interpret and discuss what the numbers mean in sentences and paragraphs as you’d do in a workplace report appeared first on Versed Writers.

Calculate your paper price
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?

Follow these simple steps to get your paper done

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

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

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.