APA FORMAT ACTIVE VOICE TIMES ROMAN 12 FREE OF GRAMMATICAL SPELLING SENTENCE STRUCTURE ERRORS FIRM GRASP OF ENGLISH LANGUAGE ZERO USE OF CONVERSATIONAL ENGLISH IN TEXT CITATIONS REFERENCE PAGE 100% PLAGIARISM FREEGrading RubricA=4=MasteryAll problems solved correctlyComplete and detailed steps are provided to explain how to solve the problem.Explanations demonstrate a mastery of understanding of the statistical concepts and terminology.All variables, equations, and expression are properly formattedCompetencyExamine basic descriptive statistics, and demonstrate results using calculated values and statistical charts.InstructionsScenario (information repeated for deliverable 01, 03, and 04)A major client of your company is interested in the salary distributions of jobs in the state of Minnesota that range from $30,000 to $200,000 per year. As a Business Analyst, your boss asks you to research and analyze the salary distributions. You are given a spreadsheet that contains the following information:A listing of the jobs by titleThe salary (in dollars) for each jobThe client needs the preliminary findings by the end of the day, and your boss asks you to first compute some basic statistics.Background information on the DataThe data set in the spreadsheet consists of 364 records that you will be analyzing from the Bureau of Labor Statistics. The data set contains a listing of several jobs titles with yearly salaries ranging from approximately $30,000 to $200,000 for the state of Minnesota.What to SubmitYour boss wants you to submit the spreadsheet with the completed calculations. Your research and analysis should be present within the answers provided on the worksheet.

The B&K Real Estate Company sells homes and is currently serving the Southeast region. It has recently expanded to cover the Northeast states. The B&K realtors are excited to now cover the entire East Coast and are working to prepare their southern agents to expand their reach to the Northeast.B&K has hired your company to analyze the Northeast home listing prices in order to give information to their agents about the mean listing price at 95% confidence. Your company offers two analysis packages: one based on a sample size of 100 listings, and another based on a sample size of 1,000 listings. Because there is an additional cost for data collection, your company charges more for the package with 1,000 listings than for the package with 100 listings.Sample size of 100 listings:95% confidence interval for the mean of the Northeast house listing price has a margin of error of $25,000Cost for service to B&K: $2,000Sample size of 1,000 listings:95% confidence interval for the mean of the Northeast house listing price has a margin of error of $5,000Cost for service to B&K: $10,000The B&K management team does not understand the tradeoff between confidence level, sample size, and margin of error. B&K would like you to come back with your recommendation of the sample size that would provide the sales agents with the best understanding of northeast home prices at the lowest cost for service to B&K.In other words, which option is preferable?Spending more on data collection and having a smaller margin of errorSpending less on data collection and having a larger margin of errorChoosing an option somewhere in the middleFor your initial post:Formulate a recommendation and write a confidence statement in the context of this scenario. For the purposes of writing your confidence statement, assume the sample mean house listing price is $310,000 for both packages. “I am [#] % confident the true mean . . . [in context].”Explain the factors that went into your recommendation, including a discussion of the margin of error

I’ll provide problems,database Only do the R hw (2 problems)Please send me as html file