10年专注于英语国家留学生作业代写,网课代修,网课Exam代考
您当前位置:主页 > Essay代写 > Paper代写 >
统计学paper代写_统计学代考_ Statistics对口大牛代笔_DueEssay论文代写、exam代考、网课代修、essay代写

统计学paper代写_统计学代考_ Statistics对口大牛代笔

Statistics统计学代写,统计学作业Assignment代写,统计学论文,统计代考,解决你的留学难题,全保密,0抄袭、无套路,24hr在线,statistics代写免费不限次修改,精准匹配,质量保证。 跟..

dueessaysanhao 立即咨询

快速申请办理

称       呼 :
联系方式 :
备       注:

统计学paper代写_统计学代考_ Statistics对口大牛代笔

发布时间:2020-11-01 热度:

Statistics统计学代写,统计学作业Assignment代写,统计学论文,统计代考,解决你的留学难题,全保密,0抄袭、无套路,24hr在线,statistics代写免费不限次修改,精准匹配,质量保证。 跟专家直接互动,统计学代考,一对一透明计费,守时守信,专业成就品质和口碑!新用户马上咨询享优惠! 24小时人工在线咨询。全托管一站式服务。高好评高回头率。

统计学paper代写,统计学代考,Statistics代写,统计代写

统计学paper代写

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.

 

PART C – Probability

 

(Use the mean and Standard Deviation, assume it’s a normal curve) Assume that the profit earned by the 80 companies in each group forms a normal curve with the mean and standard deviation as calculated in PART A.

Use Area under the normal curve theory to answer the following about the quarterly profit earned by the different groups of companies.For each part, sketch (using a drawing program if necessary), the curve showing the required area.

 

For Group A

1.What percentage of companies would you expect to earn a profit above $175,000?

2.What percentage of companies would you expect to earn a profit below $180,000?

3.How many companies would you expect to earn a profit between $160,000 and $170,000?

 

For Group B

1.What percentage of companies would you expect to earn a profit above $270,000?

2.What percentage of companies would you expect to earn a profit below $250,000?

3.What level of profit would separate the top 10% of companies?

 

For Group C

1.What percentage of companies would you expect to earn a profit above $180,000?

2.How many companies would you expect to earn a profit below $200,000?

3.Calculate the profit amounts (lower and upper limit) that define the earnings of the middle 50% of companies.

PART D – Regression

(comparing data) Copy the company group data onto a new sheet, ensuring there is an empty column between each listand sort each list individually in order from lowest to highest. The empty column between without sorting the entire 3 lists, you should).

 

1.Prepare regression analyses showing the relationship between the companies. You will need to do 3 of these; A:B, A:C and B:C.

2.Which 2 listshave the strongest relationship? How strong is it? What is the formula derived from the regression analysis which describes the relationship between the independent variable (one group) and the dependent variable (the other group)?

Use this formula to estimate the profit of the dependent variable at two levels of profit in whole $10,000’s of the independent variable. E.g.

The formula derived is: Y = 52587 + .9265X. So, if a company in Group X has a profit of $180,000, the profit of the corresponding company in Group Y is $52587 + .9265 x 180,000 = $219,357.

Your answer must appear in your Excel file using appropriate cell references and also in the Word document.

 

3.For all lists, use the formula derived from the regression analysis to estimate the mean of another list using the mean for each list calculated in PART 1. How close is the estimate to the actual answer? If they are not close, can you explain why? (Hint: Refer to your answers to PART B.)


关闭窗口
上一篇:Coursework代写_确保写作质量,提高GPA
下一篇:Research Paper代写_Mingxinwrite英语写作团队

相关阅读


代写
热门服务
Essay代写
金融
音乐Essay代写
英文Essay代写
教育学essay代写
综合Essay
Essay Writing Service
专业领域论文
本科Essay代写
美国代写
英国代写
澳洲代写
加拿大代写
Essay学科
留学essay
地区分类
essay写作
加拿大paper代写
英国paper代写
澳洲paper代写
北美paper代写
Essay学科
留学essay
地区分类
essay写作
网课代修
美国网课代修
英国网课代修
北美网课代修
管理学网课代修
经济学网课代上
商科网课代修
网课代修-国家
网课代上科目
网课作业
网课代修-国家
网课代上科目
网课作业
网课代修-国家
网课代上科目
网课作业
网课代修-国家
网课代上科目
网课作业
网课代修-国家
网课代上科目
网课作业
论文代写
文科
艺术类
哲学
历史
管理
金融
心理学
MBA代写
教育
会计
法学
传媒学
其他
数学代写
美国代写
加拿大代写
英国代写
北美代写
澳洲代写
新加坡代写
美国论文代写
英国论文代写
加拿大论文代写
澳洲论文代写
北美论文代写
PS代写
Reference Letters
Assignment代做
美国Assignment
英国assignment
加拿大assignment
澳大利亚assignment
经济学代写
商科代写
工科代写
理科代写
学校所在地
Assignment学科
coursework代写
Report代写
学校所在地
Assignment学科
coursework代写
Report代写
学校所在地
Assignment学科
coursework代写
Report代写
学校所在地
Assignment学科
coursework代写
Report代写
微信

微信客服

微信客服:dueessaysanhao

北京市海淀区学院路33号

qq

QQ客服

QQ联系:3029629821