铭信：统计学代考、exam代考、paper代写,统计学代考,Statistics代写,统计代写、Statistics统计学代写，统计学作业exam代考、assignment代写、统计学论文，统计代考、北美留学生代考、留学生exam代考、留学生代考、留学生exam代考、留学生作业代写、留学生课业代写。100%准时交付，接受12小时急单。
100%原创，均经过turnitin检测，绝无作弊。14天免费修改，不满意全额退款。现在下单，立即搞定论文！
Each assignment group has a different file.Download your group’s file from Moodle and save.（make everything look good,Header,Word&Excel）Then save it under a different name so you have two files that are exactly the same.The first is the raw data and can be kept in case of errors.The second is your working copy.This is the file you will work on.It is a good idea to save regularly using a different name so you can revert to an earlier copy if you need to.E.g.Sampson 1,Sampson 2 etc.
Complete the Student Details sheet before commencing work.You are provided with the quarterly profit figures for 3 different lists of 80 companies.The Raw Data sheet has the 3 lists together and the data relating to each list(profit for group of companies)has been copied onto the sheets following.Instructions on submission For each part you must use Excel functions to perform calculations and prepare tables as indicated.
Do not sort the data.All statistical findings and charts must be copied into a Word document.You must also prepare a written analysis of your findings.
Your submission will consist of:·Official cover sheet·Word document including a copy of all statistical findings and charts from Excel as well as analyses as outlined in the brief.·Excel file.(This is the final copy of your working file which will have the raw data provided plus your statistical operations,graphs and charts).
PART A-Descriptive statistics(Assume population)
1.Using Excel statistical functions,determine for each list,the Mean,Median,Mode,Range,Standard deviation and Co-efficient of variation.
2.Comment on the reliability of the mean as a measure of central tendency for each group of companies.Support your answer with calculations.For which group of companies is the mean the most reliable measure?
3.Draw a Box and Whisker Plot for each list.(Do in Excel or Word)
PART B–Grouping data and visual presentation
For each list,use Excel functions to perform the following:
1.Decide on a suitable class(depend on your range)interval size and use the“Bin”method to prepare a frequency table.Between 5 and 8 class intervals is best.
2.Use the frequency table to prepare a Column chart.Include a suitable title and axis labels.Format as required to make the chart look good.(Copy to Word,explain as:we have decided to use our interval because…..)
3.Prepare another frequency table including an additional class interval below and above(with 0 frequency)and use this table to prepare a line graph.Add a title and other formatting as necessary.(You can draw a curve)
4.How would you describe the curve you have created in Q3.above?Is the curve normal or skewed?If skewed,is it positive or negative?Indicate on the curve the approximate position of the mean,the median and the mode.
铭信，北美Top 20商学院导师一对一服务，成绩80%以下全额退款。免费提交作业要求，满意后付款，安全省心无顾虑。专业硕博写手团队，所有订单可靠准时，保证100%原创。如果您有意向，赶紧联系我们的客服或者添加微信：dueessay03，我们有专业水平的导师为您提供服务,让exam代考、论文写作不再犯难。
