Reference no: EM13930248
You are required to produce the attached Excel spreadsheet as identically as possible although the graph/charts may be different shapes and the number of data points may be different. Please download the Excel file called "MC4 Data" from the module Moodle web page and save it under a suitable name, i.e. your ID number followed by your surname, e.g. 12345678_Smith.xlsx. You must provide your answers in the cells indicated using appropriate Excel formulae where necessary. For Question 3, you only need to type the answers after reading off the Ogives.
Please name the data range as RawData. You MUST comment on the histogram. You must also do the following on your Excel worksheet:
1) Calculate the lower and the upper quartiles for the data. Hence, calculate the inner and outer fences to draw a box and whisker plot.
2) By looking at your whisker and box plot, are the data skewed? If so, how? Given the box-and-whisker plot, do you think the mean and standard deviation are appropriate summary statistics? (You should explain your answer briefly).
3) Draw appropriate Ogives to answer the following:
a) What percentage of sales is above £40?
b) How many transactions (sales) are there between £20 and £40?
c) What percentage of transactions (sales) falls between £30 and £50?
4. Answer Question 3, this time using appropriate Excel formulae.
Attachment:- Assignment.rar
|
Discuss the implications of given prediction
: It is reasonable to expect that given growing wealth, the emergence of a middle class, access to modern conveniences, and so forth, the "emerging" countries of the world may experience exponential growth in energy consumption over the short to med..
|
|
Describe gayle level of intelligence based on cogat scores
: How would you describe Gayle's overall level of intelligence based on the CogAT scores? How would you describe her overall level of achievement based on her scores on the WJ III ACH?
|
|
Design and implement a rmi-based client
: In this assignment, you are requested to build a system which allows a school pupil to practise multiple choice tests in math. Design and implement a RMI-based Client / Server communication system in Java, which will do the following:
|
|
Determine the true cash balance by preparing a bank
: Record in general journal format the adjusting entries necessary to correct the unadjusted book balance.
|
|
Calculate the lower and the upper quartiles for the data
: Calculate the lower and the upper quartiles for the data. Hence, calculate the inner and outer fences to draw a box and whisker plot
|
|
The unadjusted balance per the bank statement
: The unadjusted balance per the bank statement on August 31 was $35,200.
|
|
Campaign speech
: Campaign Speech Read the following scenario. "Alcohol and drug abuse are associated with crime on the streets, health problems, the breakdown of the family, and poor
|
|
Industries shape notions of gender
: In this lesson, we will take a look at the advertising and media industry, and how these industries shape notions of gender. We will learn about what we now call theconstruction of gender-the ways in which terms like sex, gender, masculinity, and fem..
|
|
How is the measure of beck depression inventory used
: How is the measure of Beck Depression Inventory used? Who is qualified to administer and interpret the measure and the settings? What are some differences between the populations for which Beck Depression Inventory is valid or invalid?
|