Prepare Data Set And Analyse Data Report Writing - IT Assignment Help

Assignment Task

Step 1: Prepare Data Set
•    You need to download and modify the generic data set to identify the sample you will be working on. \
•    Important: You do not need to analyse the entire data set – only draw a random sample of 200 households. This must be done first and the rest of your statistical analysis will be based on this data set.
 

Step 2: Analyse Data & Submit Report 
•    You will be presented with a set of tasks to run on your unique data set (of 200 samples) 
•    As much as possible, complete these tasks within the excel document. You will need to submit your excel document at the end of the assignment.
•    You will also submit a brief report in word addressing all the tasks below. When responding to the tasks, please explain the reasoning behind your answer, and refer to your Excel sheet
 

Task 1
A.    Draw a random sample of two hundred (200) households as per the sample selection procedure. What sampling method have you used to select your sample data? In your opinion, is this the best method of sampling, why or why not?
The sample data was collected using the random sampling method. In my opinion this is the best method of sampling because it reduces the risk of any bias. 
B.  Compute the descriptive statistics and draw a Box-Whisker plot of Expenditures on the following variables (all series in one graph!);
  (i) Alcohol      (ii) Meals          (iii) Fuel              (iv) Phone
C.  Also, use an appropriate measure of variation to compare the variability in expenditures on these four variables. Explain, why is this an appropriate measure.
D.  Present a summary of your findings regarding the shape and spread of the distribution of these variables using information from the boxplots and the descriptive statistics.

This IT Assignment has been solved by our IT experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.
Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.