BEO2255 Applied Statistics For Business - Group Report Part 2 - Assignment Help

Assessment Overview


Detail Length Weighting Due
You are required to Analyse a given business related data set using appropriate statistical techniques with the use of Excel functionalities and provide interpretations in understanding real-world business problems.

The purpose of this assignment is to:

Demonstrate your ability to work with other team members as a ‘team of business analysts’ in analysing and interpreting a business related data files. 

Review Content Session 5 & 6 in preparation for this assessment task.

No page limit 15% End of Week 2: session 6

Learning Outcomes


The learning outcomes for Part two of the group assignment are LO 3, 4 and 5.

  • LO 3:  Analyse business related data using appropriate SPSS/Excel functionalities to provide specific recommendations to real-world business problems;
  • LO 4:  Derive statistical models using statistical findings and make use of such findings in writing reports to evaluate alternative policy options and justify recommendations in decision making; and
  • LO 5: Exhibit effective interpersonal skills to successfully collaborate with and influence others in teams to achieve group outcomes whilst maintaining responsibility and accountability of own learning and professional practice.

Instructions


    1. This group assignment requires 3 members in each group.
    2. You are advised to form your own groups and once finalised the grouping arrangement will not be changed unless there are compelling reasons to do so.  
    3. Your assignment must include names of each group member, including student IDs.
    4. No single-authored submission will be accepted.

Assessment Structure and Requirements

Details


The top management of a fashion store operating in three different cities in Victoria wanted to check whether there is a relation between weekly sales and store location. In this experiment, three different store locations are considered: Melbourne, Geelong, and Bendigo, and four different lines of products are considered: Clothing, Footwear, Perfumes and Accessories. The file Assessment 2 Data contains 160 observations from a hypothetical random sample of one week sales of the product assigned to each display location. You are required to select 100 observations for your own data set.  The variables are as follows:

SALES  One-week average sales ($AUD) of the products
CITY  Store Location: 1 = Melbourne, 2 =  Geelong, and 3 = Bendigo
PRODUCT  1= Clothing, 2 = Footwear, 3 = Perfumes and 4 = Accessories
PROMOTION 1= TV and Radio, 2 = Social Media, 3 = Newspapers, and 4 = Leaflets & Brochures

(1) Conducting One-way ANOVA;

You are required to conduct a One-way ANOVA to test the null hypothesis that means sales are the same in all store locations.

(2) Based on your results from Q1 above, is there any statistically significant mean difference in sales between pair of store locations (i.e. between Melbourne & Geelong, between Melbourne & Bendigo, between Geelong & Bendigo?).

(3) Kruskall-Wallis test

Use a Kruskall-Wallis test of the null hypothesis that the distributions of sales are the same for all three store locations.  

(4) Is the Sales data sufficiently non-normal to warrant the non-parametric test instead of one-way ANOVA? (Hint: In your answer to this question, you are expected to revisit the result obtained from Q1).  

(5) Conducting Two-way ANOVA

You are required to conduct a Two-way ANOVA to test the null hypothesis that the mean sales are the same for all products and promotions. Allow for the possibility of an interaction effect between the products and promotions.

(6) Produce Tukey Confidence Intervals for the row and column differences. Report only where the differences are statistically significant. Interpret the significant confidence intervals.

Page Limit

No page limit for the group report however you are advised to present the report in a professional manner. 

Presentation: General guidelines

  • Your assignment must be presented on Microsoft Word.
  • You are required to write the report to suit the academic standards.
  • Attach an assignment declaration with your name and ID numbers clearly written.
  • All tables and figures should contain a title that clearly explains the content.
  • If you are copying Excel table outputs, they should be formatted to suit the presentation of report.
  • Please email your instructor a copy of your group assignment by the due date.

Expert's Answer

Chat with our Experts

Want to contact us directly? No Problem. We are always here for you

Professional

Online Tutoring Services

17,148

Orders Delivered

4.9/5

5 Star Rating

748

PhD Experts

 

Amazing Features

Plagiarism Free

Top Quality

Best Price

On-Time Delivery

100% Money Back

24 x 7 Support

Ask a New Question
*
*
  • United States+1
  • Afghanistan+93
  • Albania+355
  • Algeria+213
  • American Samoa+1684
  • Andorra+376
  • Angola+244
  • Anguilla+1264
  • Antigua and Barbuda+1268
  • Argentina+54
  • Armenia+374
  • Aruba+297
  • Australia+61
  • Austria+43
  • Azerbaijan+994
  • Bahamas+1242
  • Bahrain+973
  • Bangladesh+880
  • Barbados+1246
  • Belarus+375
  • Belgium+32
  • Belize+501
  • Benin+229
  • Bermuda+1441
  • Bhutan+975
  • Bolivia+591
  • Bosnia and Herzegovina+387
  • Botswana+267
  • Brazil+55
  • British Indian Ocean Territory+246
  • British Virgin Islands+1284
  • Brunei+673
  • Bulgaria+359
  • Burkina Faso+226
  • Burundi+257
  • Cambodia+855
  • Cameroon+237
  • Canada+1
  • Cape Verde+238
  • Caribbean Netherlands+599
  • Cayman Islands+1345
  • Central African Republic+236
  • Chad+235
  • Chile+56
  • China+86
  • Christmas Island+61
  • Cocos (Keeling) Islands+61
  • Colombia+57
  • Comoros+269
  • Congo (DRC) (Jamhuri ya Kidemokrasia ya Kongo)+243
  • Congo (Republic) (Congo-Brazzaville)+242
  • Cook Islands+682
  • Costa Rica+506
  • Cote d'Ivoire+225
  • Croatia+385
  • Cuba+53
  • Curacao+599
  • Cyprus+357
  • Czech Republic+420
  • Denmark+45
  • Djibouti+253
  • Dominica+1767
  • Dominican Republic+1
  • Ecuador+593
  • Egypt+20
  • El Salvador+503
  • Equatorial Guinea+240
  • Eritrea+291
  • Estonia+372
  • Ethiopia+251
  • Falkland Islands+500
  • Faroe Islands+298
  • Fiji+679
  • Finland+358
  • France+33
  • French Guiana+594
  • French Polynesia+689
  • Gabon+241
  • Gambia+220
  • Georgia+995
  • Germany+49
  • Ghana+233
  • Gibraltar+350
  • Greece+30
  • Greenland+299
  • Grenada+1473
  • Guadeloupe+590
  • Guam+1671
  • Guatemala+502
  • Guernsey+44
  • Guinea+224
  • Guinea-Bissau+245
  • Guyana+592
  • Haiti+509
  • Honduras+504
  • Hong Kong+852
  • Hungary+36
  • Iceland+354
  • India+91
  • Indonesia+62
  • Iran+98
  • Iraq+964
  • Ireland+353
  • Isle of Man+44
  • Israel+972
  • Italy+39
  • Jamaica+1876
  • Japan+81
  • Jersey+44
  • Jordan+962
  • Kazakhstan+7
  • Kenya+254
  • Kiribati+686
  • Kosovo+383
  • Kuwait+965
  • Kyrgyzstan+996
  • Laos+856
  • Latvia+371
  • Lebanon+961
  • Lesotho+266
  • Liberia+231
  • Libya+218
  • Liechtenstein+423
  • Lithuania+370
  • Luxembourg+352
  • Macau+853
  • Macedonia+389
  • Madagascar+261
  • Malawi+265
  • Malaysia+60
  • Maldives+960
  • Mali+223
  • Malta+356
  • Marshall Islands+692
  • Martinique+596
  • Mauritania+222
  • Mauritius+230
  • Mayotte+262
  • Mexico+52
  • Micronesia+691
  • Moldova+373
  • Monaco+377
  • Mongolia+976
  • Montenegro+382
  • Montserrat+1664
  • Morocco+212
  • Mozambique+258
  • Myanmar (Burma)+95
  • Namibia+264
  • Nauru+674
  • Nepal+977
  • Netherlands (Nederland)+31
  • New Caledonia+687
  • New Zealand+64
  • Nicaragua+505
  • Niger+227
  • Nigeria+234
  • Niue+683
  • Norfolk Island+672
  • North Korea+850
  • Northern Mariana Islands+1670
  • Norway (Norge)+47
  • Oman+968
  • Pakistan+92
  • Palau+680
  • Palestine+970
  • Panama+507
  • Papua New Guinea+675
  • Paraguay+595
  • Peru+51
  • Philippines+63
  • Poland+48
  • Portugal+351
  • Puerto Rico+1
  • Qatar+974
  • Reunion+262
  • Romania+40
  • Russia+7
  • Rwanda+250
  • Saint Barthelemy+590
  • Saint Helena+290
  • Saint Kitts and Nevis+1869
  • Saint Lucia+1758
  • Saint Martin+590
  • Saint Pierre and Miquelon+508
  • Saint Vincent and the Grenadines+1784
  • Samoa+685
  • San Marino+378
  • Sao Tome and Principe+239
  • Saudi Arabia+966
  • Senegal+221
  • Serbia+381
  • Seychelles+248
  • Sierra Leone+232
  • Singapore+65
  • Sint Maarten+1721
  • Slovakia+421
  • Slovenia+386
  • Solomon Islands+677
  • Somalia+252
  • South Africa+27
  • South Korea+82
  • South Sudan+211
  • Spain+34
  • Sri Lanka+94
  • Sudan+249
  • Suriname+597
  • Svalbard and Jan Mayen+47
  • Swaziland+268
  • Sweden (Sverige)+46
  • Switzerland+41
  • Syria+963
  • Taiwan+886
  • Tajikistan+992
  • Tanzania+255
  • Thailand+66
  • Timor-Leste+670
  • Togo+228
  • Tokelau+690
  • Tonga+676
  • Trinidad and Tobago+1868
  • Tunisia+216
  • Turkey+90
  • Turkmenistan+993
  • Turks and Caicos Islands+1649
  • Tuvalu+688
  • U.S. Virgin Islands+1340
  • Uganda+256
  • Ukraine+380
  • United Arab Emirates+971
  • United Kingdom+44
  • United States+1
  • Uruguay+598
  • Uzbekistan+998
  • Vanuatu+678
  • Vatican City+39
  • Venezuela+58
  • Vietnam+84
  • Wallis and Futuna+681
  • Western Sahara+212
  • Yemen+967
  • Zambia+260
  • Zimbabwe+263
  • Aland Islands+358
*
*
*

TOP

Connect on WHATSAPP: +61-416-195006, Uninterrupted Access 24x7, 100% Confidential

X

Your solution is just a click away! Get it Now

PrevNext
MoTuWeThFrSaSu
31123456
78910111213
14151617181920
21222324252627
2829301234