Purchase Solution

Statistics Project Using Microsoft Excel

Not what you're looking for?

Ask Custom Question

Read the attached case study and complete the following:
1. Prepare a report exploring the data your team collected for the management of SJGR. This report should contain the results of the various data exploratory data analyses tools such as scatter charts, histograms, correlation coefficients, etc. and the interpretation of these.

2. The management of SJGR is interested in finding out about the average perceptions of SJGR (X1 - X7) by all of its customers. On the basis of your sample of 100 customers, tell the management what you can about the average perceptions of SJGR by all its customers.

3. The management of SJGR believes that different kinds of customers (defined in terms of income level X9 and gender X10) have different purchasing behaviour. Managers believe that, on average, higher income customers tend to buy a different percentage of their groceries at SJGR from the percentage bought by all other customers, and men buy a different percentage of their groceries at SJGR onaverage from the percentage bought by women. Test statistically whether these particular beliefs about the effects of income and gender are justified by the evidence, and report on your tests and findings.

4. SJGR's management would like to be able to predict purchasing behaviour, as measured by X8, on the basis of customers' ratings of SJGR's attributes (variables X1 to X7). Develop a regression model using variables X1 to X7 as independent variables and report on your findings.

5. Based on the results from questions 1, 2, 3 and 4, prepare recommendations (of maximum length 2 pages) for the managers of SJGR on how they can improve the purchasing behaviour of SJGR customers. Your total report (excluding appendices) should be not more than 12 pages. You may attach an appendix to show details of your working. If you do attach an appendix, the total report on parts 1 to 5 above - excluding the appendix - should provide everything that management needs in order to understand what you have done, what you have found out, and what you are recommending, with your reasons.

Attachments
Purchase this Solution
Solution Summary

This is a case study on Sir John's Gate retail and their management.

Purchase this Solution
Free BrainMass Quizzes
Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

View More Free Quizzes
Related BrainMass Solutions

  • Project Management Tools.

    How could you use spreadsheets, such as Microsoft Excel? How could you use scheduling tools, such as Microsoft Project? Share some tips for using either of these products.

  • Calculation of Descriptive Statistics using the Excel

    This solution is comprised of a detailed explanation of descriptive statistics using the Microsoft Excel.

  • Project Management and the use of project management tools

    www.cse.psu.edu/~lambert/420/big/node89.html In other word, Project Management tools track the progress of the project using the information using information from Excel, MS project, etc.

  • PERT, CPM, Gantt, Work Breakdown Structures

    It is recommended for the project team to keep the track or record of original as well as current estimates of the project while using either Microsoft Excel or Microsoft Project.

  • Tools for project risk management

    When there are dependencies between multiple projects Excel can be utilized to perform advanced risk analysis of project using techniques like ANOVA (Analysis of Variation), Monte Carlo simulations, etc.

  • NPV, IRR, PI and Payback Period

    Calculate the following values for each project using the time value tables and Microsoft Excel. A) NPV B) IRR (round to the nearest whole percentage using Microsoft Excel "IRR" function.)

  • Statistics

    Using the data listed above in problem 1, calculate by hand the standard deviation. b. Using Microsoft Excel, type 'Ratings' in column A, cell 1. Below cell one, start typing your data in the A column. c.

  • Developing a Communication Plan for New Infrastructure

    - Friday: Recapping project current status before Monday mandatory staff meeting with stakeholders by using Microsoft Excel that outlines all project data associated with the project.

  • Hypothesis Testing: Intrinsic & Extrinsic Job satisfaction

    Perform a two-tailed hypothesis test on both the intrinsic and the extrinsic variable's data, using a .05 significance level. 2. Begin by creating a null and an alternate statement. 3. Use Microsoft Excel to process your data.

  • Organisational Process Recommendation - Quality Textiles

    Information on adding and using the Analysis ToolPak can be found using the Help feature in Microsoft® Excel®. ï?· Calculate the upper control limit and lower control limit.

View More Related Solutions