# 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.

Pages (550 words)
Approximate price: -

Quality Researched Papers

We always make sure that writers follow all your instructions precisely. You can choose your academic level: high school, college/university or professional, and we will assign a writer who has a respective degree.

Qualified Writers

We have hired a team of professional writers experienced in academic and business writing. Most of them are native speakers and PhD holders able to take care of any assignment you need help with.

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. You can do this yourself after logging into your personal account.

Prompt 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. We will always strive to deliver on time.

Original & Confidential

We use several writing tools checks to ensure that all documents you receive are free from plagiarism. Our editors carefully review all quotations in the text.

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.

If you are looking for exceptional academic writing services, then you are in the right place. Studyacer offers customised academic assignments and academic papers for students at all levels.

## Essay Writing Help

Writing an essay can be a challenge. However, we know what every student needs. And we purpose to deliver. Here at StudyAcer, we do all we can to help with academic essays and assignments. We have a dedicated team of professional essay writers.

Assignment Help

We understand students need satisfactory results. Our cheap assignment writing service helps and never leaves any doubt. We always strive to ensure the ultimate and best results. It is our joy to offer a cheap reliable essay writing service.

Term Paper Help

Have you been asking yourself, where can get a pre written research papers for sale? Worry no more, the fact that you have a term paper that is due tonight and you haven’t touched it. At Study Acer it is our responsibility to get your paper on time.

Dissertation Writing Service

Several master’s students seek professional help with their thesis.Students from different parts of the world experience different challenges. Dissertations have different stages and the challenges are different too. Do not struggle in silence, order now .