Statistics REPORT This the assignment is worth 40% of the overall assessment This is a group assignment (of 2 students per group). The written report must be a written, self-contained report and...

1 answer below »



Statistics

REPORT




This the assignment is worth 40% of the overall assessment


This is a group assignment (of 2 students per group). The written report must be a written, self-contained report and professionally presented. The written component of this assessment must be a maximum of 1800 words.


It's due on 16/10/2019


I am a first-year statistics student, and I have no proper knowledge of this subject (so please don't put any the information which is first statistics students are not familiar with (abbreviation, etc.)


In my business report, you have to compare two samples. Which is provided in excel in (sheet 1 & 2) and needs to answer the question based on the item I have provided below. Please show us the method of the solution if you do any mathematical problems like equation or formula.


This report must be professionally presented.


Don't plagiarize from the internet, books or social media and All the answer needed to be answered by yourself moreover all other works should write in simple English with proper grammar and Academic Reference is Expected if any information taken from outside.


All the answers needed to be Explain, example, and link back to the question. All question answer needed to complete, with efficiently and abbreviations are not acceptable like (N/A), org ), . should have to give reasons (, why, when, where, how, what, cause) if it's necessary


If the report is asking to do draw graphs, you have to draw it.




Needed to know how to use EXECL








BUSINESS REPORT This assignment is worth 40% of the overall assessment This is a group assignment (of 2 students per group). The written report must be a typed self contained report and professionally presented. The written component of this assessment must be a maximum of 1800 words. Its due on 16/10/2019 I am a first-year statistics student, and I have no good knowledge of this subject (so please don't put any kind of the information which is first statistics students are not familiar with (abbreviation, etc.) In my business report, you have to compare two samples. Which is provided in excel in (sheet 1 & 2) and needs to answer the question based on the question I have provided below. Please show us the method of the solution if you do any mathematical problems like equation or formula. This report that must be professionally presented. Don't plagiarize from the internet, books or social media and All the answer needed to be answered by yourself moreover all other works should write in simple English with good grammar and Academic Reference is Expected if any information taken from outside. All the answers needed to be explain, example and link back to the question. All question answer needed to complete, with efficiently and abbreviations are not acceptable like (N/A), org ), . should have to give reasons (, why, when, where, how, what, cause) if it's necessary If the report asking to do draw graphs, you have to draw it. BUSINESS REPORT You are required to obtain 1 random sample containing 25 householders from this population – using an appropriate random sampling technique. Analyse the sampled data and write a report to provide useful information that a Supermarket management team can use to make decisions regarding improved services to their clients. Your analysis and report must demonstrate the application of the various techniques you have learned in this course. Introduction (20 marks) Your introduction should state the aim of your project (you need to explain how you will use the information obtained and the types of analytical tools you will utilise to write a comprehensive report A brief description of the overall population data should be given (this will give you a hint as to how you will need to sample). An explanation of how your random sample was obtained. ( a copy of the sample data needs to be submitted as part of the Appendix) Data Analysis (60 marks). Descriptive Statistics (20 marks). Give a detailed description of the demographic profile of your sample. The data provided in the various columns will give you ample Information. You need to be organised and determine systematically the types of information that you think would be useful to assist the supermarket chain to make accurate business decisions. Demographic Information such as: average age of your sample; average household income; size of households; marital status, do they live in close proximity to the supermarket; in which zone do the majority of your households live in and what information can you derive about the zones; average yearly purchases; debt levels; proportion of debt to income level, etc., will provide an insight for the business decision makers. Information such as differences in spending habits according to gender; do males generally earn more than females? Do the zone area they live in influence spending habits? (I am sure you can derive more interesting findings!) Explain how the information that you have collected will assist. Provide both numerical and graphic summaries to support your report. Inferential Statistics (10 marks) Management of the supermarket chain claims that for a significant increase in spending to improve services, the average yearly spending on supermarket purchases needs to be at least $2387. From the samples you have collected, is there sufficient evidence to support the claim? Analysis of relationships (30 marks) In the analyses of relationships, you can use regression and correlation analyses or simple crossed tabulations to provide insights. There are a number of relationships that can be analysed and provide additional information for the decision makers. For example, you may want to determine if there is a relationship between the household income levels and the amount spent on supermarket purchase; or does the size of the household influence the amount spent on supermarket purchase; what about the ratio of debt (mortgage and other) to income level –does this influence purchases? (Note: It is necessary to demonstrate the use of regression analysis in at least one bivariate relationship). Summary/Discussion and Conclusion (20 marks) Provide a short summary of the MAIN results from your overall analysis. Do you think the data provided here are sensible and reliable? Do they provide sufficient information for the Supermarket chain to make decisions about potential supermarket locations? If not, what suggestions would you recommend? You were asked to obtain two samples using two different sampling techniques. From the results you obtained, were there any significant differences? (100 marks) A marking rubric is available on your Moodle site and is also made available on the following page.
Answered Same DayOct 13, 2021

Answer To: Statistics REPORT This the assignment is worth 40% of the overall assessment This is a group...

Pritam answered on Oct 16 2021
130 Votes
Introduction:
The objective of this project is to find some ample information and some interactions between some general attributes of different individuals based on fictitious data. Sampling technique has been used to create a sample of twenty-five households and then further data analysis has been performed. The attributes consist of variables like age group, the gender of the person, marital status, number of children in the family, outstanding mortgage owing on home, the closeness to the supermarket for the person living there, the zone of living and the yearly purchased value for the person. The variables need
some clarification on their behalf before any further analysis. The age is actually considered as a dummy variable with three different levels 1, 2 and 3. The first level corresponds to the persons of 30 years old or younger. The second level contains the age category between 31 and 55 years and lastly, the last level of the age group corresponds to 56 years old or older. Gender has two categories as male and female. The marital status has also two categories such as single or married. The salary column actually represents the average household salary for the particular person. Mortgage represents the outstanding mortgage owing to home. Debt represents average amount of non-mortgage debt. Invested column shows the percentage of combined income invested in tax-deferred retirement plans. Close has two categories and presented in the data as a dummy variable with two levels. 1 represents that the person lives close to the market and 0 represents he lives out in the middle of nowhere. Finally, the last column corresponds to the yearly purchase of the family of that particular person. Basic descriptive statistics are given at the beginning of the data analysis section and then different claims and relationships between the variables have been done. In fine, a regression analysis is done followed by a conclusion of the whole report. The main findings have been reported accordingly in the data analysis part with proper use of statistical tests and visualization techniques.
Data analysis:
Descriptive statistics:
Firstly, a descriptive summary table is given to understand the data closely. The summary table is given below. The numerical variable has been considered only for the descriptive statistics part.
    Statistics
     Salary
     Mortgage
     Debt
    Invested
    Amount Spent
    
    
    
    
    
    
    Mean
    75466
    90175.6
    9519.356
    0.06256
    2462.496
    Standard Error
    4531.666
    5188.544
    917.8474
    0.009047
    172.184
    Median
    74390
    99600
    9880
    0.068
    2276.944
    Mode
    #N/A
    101510
    #N/A
    0.078
    2500
    Standard Deviation
    22658.33
    25942.72
    4589.237
    0.045236
    860.9199
    Sample Variance
    5.13E+08
    6.73E+08
    21061097
    0.002046
    741183
    Kurtosis
    0.135382
    -0.02175
    -1.17595
    -0.81266
    2.583207
    Skewness
    0.291257
    -0.73735
    0.103231
    0.218906
    1.473062
    Range
    94190
    103460
    15330
    0.15
    3605.286
    Minimum
    36370
    24580
    1620
    0
    1544.714
    Maximum
    130560
    128040
    16950
    0.15
    5150
    Sum
    1886650
    2254390
    237983.9
    1.564
    61562.4
    Count
    25
    25
    25
    25
    25
From the summary, one can see that the average salary for the 25 households sample is nearly around 75466 dollars. The sample variance of the salary is quite high implying that the spread of the data around the mean is quite large. In this sample, the minimum and the maximum salaries are found to be 36370 and 130560 dollars respectively. The mortgage for this sample is also quite high again with a very high variance. The debt seems to be a little bit higher than the mortgage. On the other hand, the average investment for the retirement plans seem to be quite low at 6% only and the sample variance is very low which implies that the data is not much spread out around the mean and may be expected to fluctuate nearly around 6%. The yearly purchase for the family is found to be nearly around 2462 dollars.
Pie Chart:


It is evident from the pie-chart that the female percentage is greater in the sample. Majority of the households in the sample come from C zone.
Pivot tables and Visualization techniques:
To analyze the interaction between the dummy variables and the numerical variables, different pivot tables and the corresponding chart can be produced to check the data more closely. The first table is based on the interaction between age and other numerical variables. Specifically, the distribution of different numerical data has been shown below.
    Row Labels
    Average of Salary
    Average of Mortgage
    Average of Debt
    Average of Invested
    Average of Amount Spent
    1
    73216.25
    81957.5
    10775.85
    0.061
    2299.21
    2
    77402.85714
    95712.85714
    8943.192857
    0.068714286
    2624.4541
    3
    72426.66667
    86250
    8857.466667
    0.038
    2142.12
    Grand Total
    75466
    90175.6
    9519.356
    0.06256
    2462.4959
What important can be noticed here is that the middle age group seem to have a higher salary and higher mortgage also at the same time. But that doesn’t vary so much across the three age groups. Between the younger and the older age group the salary or the mortgage seems to be nearly close to each other. It is also evident that the average amount spent yearly is the highest among the middle-aged groups.
Another table can be produced based on zones and the proximity of the living or closeness to the supermarket. The tables and charts are given below.
    Row Labels
    Average of Salary
    Average of Mortgage
    Average of Debt
    Average of Amount Spent
    A
    36370
    74260
    11860
    1695.1
    B
    41185
    103655
    8130
    1856.57
    C
    75157.36842
    93488.42105
    9648.836842
    2412.629359
    D
    113306.6667
    65513.33333
    8845.333333
    3438.066667
    Grand Total
    75466
    90175.6
    9519.356
    2462.495913
In our sample, it is found that A, B, C, D, and E are found in terms of zones. The average salary and the average amount spent are both found to be the highest in zone D but the average mortgage is higher in zone B. Whereas the highest average debt is found in zone A.

    Row Labels
    Average of Amount Spent
    Average of Debt
    Average of Invested
    Average of Mortgage
    Average of...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here