Before you begin your analysis, you are required to take a random sample of size…
[ad_1]
Agriculture And Forestry Excel Solver Problem Included 19681327February 19, 2021It is estimated that 30 percent of all the trees It is estimated that 30% percent of all the trees..February 19, 2021Random SampleBefore you begin your analysis, you are required to take a random sample of size200 from the 253 cases in the file. Use the file Sample-Generator.xls to do this.Your tutor will show you how this can be done in EXCEL. Your answers to thequestions below are to be based on your sample of 200 cases. Make sure to keep asafe copy of your sample since you cannot use Sample-Generator to reproduce thefirst sample. Provide a printout of the data in your sample, with ID numbers inascending order.Part 1: Initial Data AnalysisTask 1: Variable ListUsing the variables listed in the table above, state for each variable whether it isqualitative or quantitative; if it is qualitative, state whether it is nominal or ordinal,and if it is quantitative, state whether it is discrete or continuous.Task 2: HistogramCreate a histogram showing the distribution of salaries. Comment upon the shape ofthe distribution: is it symmetric? If it is not, is it positively or negatively skewed?Are there any outliers present? If so, are they of particular interest?State which central measure would be best to use to describe the centre of thisdistribution, and the reason(s) why.Task 3: Descriptive StatisticsPrepare a table that shows the 5-number summary and standard deviation of salary forthe five work areas. Construct side-by-side boxplots for the salaries. Brieflycomment upon any differences you observe in salaries for each work site. “Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!” “Is this question part of your assignment? We Can Help!”