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 three analysis packages: one based on a sample size of 100 listings, one based on 1,000 listings, and another based on a sample size of 4,000 listings. Because there is an additional cost for data collection, your company charges more for the package with 4,000 listings than for the package with 100 listings.Bronze Package - Sample size of 100 listings:95% confidence interval for the mean of the Northeast house listing price has a margin of error of $24,500Cost for service to B&K: $2,000Silver Package - Sample size of 1,000 listings:95% confidence interval for the mean of the Northeast house listing price has a margin of error of $7,750Cost for service to B&K: $10,000Gold Package - Sample size of 4,000 listings:95% confidence interval for the mean of the Northeast house listing price has a margin of error of $3,900Cost for service to B&K: $25,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 all packages. “I am [#] % confident the true mean . . . [in context].”Explain the factors that went into your recommendation, including a discussion of the margin of errorFor your response posts to your peers, choose two different confidence intervals for your responses. Do you think the agents would prefer a different confidence interval than their management? What advantages and disadvantages would there be in having different confidence intervals for the agents? Explain your thought process and reasoning in your response.

The Excel spread sheet and pdf is for Experience 2 Application only.EXPERIENCE 3 ASSISGNMENT Suppose you are representing the employees at a large corporation during contract negotiations. You have a list of the salaries of all the employees at the corporation (The salaries include the many lower level employees and the few high paid management employees) and you plan to find a measure of center (e.g. mean, median, or mode).a. Which measure or center would you use to represent the employees in an effort to support your claim that the average salary of lower level employees is much lower than the national average (for lower level employees) and thus should be increased?meanmodemedianb. Why is this the better choice?Suppose you wish to invest money safely and are trying to decide between stock options in two companies. The average rates of return are the same for both companies but, one company has a much larger standard deviation of its rates of return. a. Which company should you invest in?The company with the smaller standard deviationThe company with the larger standard deviationb. Why is this the better choice? Describe the shape of the distribution for the following and justify your answer:a. The distance people travel to work on a typical day - The horizontal axis is the distance traveled in a person's daily commute. The vertical axis is frequency (number of people with that distance for their daily commute). Shape of distribution:skewed leftuniformskewed rightsymmetricJustification:b. Number of hours of sleep for each night of the week (weekdays only) - The horizontal axis is the day of the week (Monday to Friday) and the vertical axis is the amount of sleep in hours for that night. Shape of distribution:symmetricuniformskewed leftskewed rightJustification:c. Age of first heart attack - The horizontal axis is age. The vertical axis is frequency (number of people who had their first heart attack at that age). The population is people in the US who have had at least one heart attack. Shape of distribution:uniformsymmetricskewed leftskewed rightJustification:d. Scores on the Graduate Requirement Exam - This is a standardized test for people entering graduate school. The horizontal axis would be the person's total score. The vertical axis would be frequency (number of people with that score). The population would be all GRE test takers for a given year. Shape of distribution:symmetricskewed rightuniformskewed leftJustification:EXPERIENCE 2 APPLICATIONYou must use spreadsheet software (e.g. Excel) for this problem. 1. For each state and Washington DC, the percentage of people without health insurance was determined. Given the data set (The file is located in the main Experience folder) create the following using spreadsheet software. Refer to the model/methodology for the desired format. Make sure to use 5-20 classes with a "nice" class width when creating the distribution tables. Make sure to label axes in both graphs. a. Grouped frequency distribution (table) b. Grouped relative frequency distribution (table) c. frequency histogram (graph) d. relative frequency histogram (graph) Submit the completed spreadsheet as a .xls or .xlsx file. 2. A survey of 50 college students was conducted to determine how much weekly income they earned from employment. Given the data set in Applications folder for this experience complete the following. Refer to the model/methodology for the desired format. a. Find the 5 number summary of the data set. Min= Q1= Median= Q3= Max= b. Create a box-plot for the data set using software (Choices include: The boxplot generator linked in the resources area, spreadsheet software, TI-84 (take a picture of your calculator), other software or websites.) Upload your finished file below. Question 2 Part 6 of 9Choose File No file chosen c. Identify any outliers. List the individual numbers that are outliers for this data set. If there are multiple outliers, separate them by commas. d. Give a possible explanation as to why the individual (or individuals) from part c might have a number (or numbers) that are so high (or so low). e. Interpret yourself as a percentile in the data set. First estimate your weekly income from employment (If you are not employed then use 0). Then find the percentile (see book for the formula) for your income using the sample data. Then interpret the percentile using the definition and writing a complete sentence.

Submit a synthesis of statistical findings derived from ANOVA that follows the Week 4 Assignment Template. Your paper must include the following:•A description and justification for using the one-way ANOVA•A properly formatted research question•A properly formatted H0(null) and H1 (alternate) hypothesis•An APA-formatted “Results” section for the one-way ANOVA •Identification of the statistical test•Identification of independent and dependent variables, including the identification of the number of levels for the independent variable•Identification of data assumptions and assessment outcome•Inferential results in correct APA statistical notation format•A properly formatted box plot•A discussion on how you would extend the one-way ANOVA to a two-way ANOVA using the variables in the Week 4 Data File for One-way ANOVA.sav dataset.•Properly APA-formatted references•Appendix containing SPSS output (see Week 4 Assignment Exemplar)Note: You will cut and paste the appropriate SPSS output into the Appendix. The SPSS output is not in APA format, so you will need to type the information from the SPSS output to the appropriate sections of the APA table. Be sure to use the Week 4 Assignment Template to complete this Assignment. Also, refer to the Week 4 Assignment Rubric for specific grading elements and criteria. Your Instructor will use this rubric to assess your work.Submission and Grading InformationTo submit your completed Assignment for review and grading, do the following: •Please save your Assignment using the naming convention “WK4Assgn+last name+first initial.(extension)” as the name. •Click the Week 4 Assignment Rubric to review the Grading Criteria for the Assignment.•Click the Week 4 Assignment link. You will also be able to “View Rubric” for grading criteria from this area.•Next, from the Attach File area, click on the Browse My Computer button. Find the document you saved as “WK4Assgn+last name+first initial.(extension)” and click Open. •If applicable: From the Plagiarism Tools area, click the checkbox for I agree to submit my paper(s) to the Global Reference Database.•Click on the Submit button to complete your submission.