I need this assignment done by May 17th, 2022 at 11:59 PM. This is an Honors Algebra 1 Honors Project.

In case you need high-quality essay, we are here to help you. Would you like us to handle your paper? Use our writing services for better grades and meet your deadlines.


Order a Similar Paper Order a Different Paper

I need this assignment done by May 17th, 2022 at 11:59 PM. This is an Honors Algebra 1 Honors Project.

I need this assignment done by May 17th, 2022 at 11:59 PM. This is an Honors Algebra 1 Honors Project.
Math | Project Overview | Company Data Project Overview Company Data Review the requirements for completing the project. This project is worth 45 points. Introduction and GoalsIn this project, you will play the role of a statistician hired to analyze employee data for a company. First, you will access employee records and find measures of central tendency and variability for two departments within the company. You will incorporate box-and-whisker plots into the summary of your findings and help the owner of the company interpret them. You will find the data in a spreadsheet. You do not have to calculate statistics by hand; you can use your graphing calculator or the spreadsheet’s calculation features. Then you will use a sampling method to select a group of employees who will take a test to assess their computer skills. You will make a frequency table and histogram of this data. Finally, you will use technology to draw scatter plots and display trend lines for employee data and you will discuss correlations for different pairs of data Schedule of Completion Day 1: Group Comparisons Day 2: Samples and Histograms Day 3: Scatter Plots Day 4: Continue Working on Scatter Plots Day 5: Make Data-Based Predictions Project Instructions Before beginning, read through the Project Overview to understand the entire project. Also, each day, make sure to read each section thoroughly before completing your assignment. Template Download the Project Template and rename the file as CompanyData_YourName. This file will become your presentation. Group Comparisons The owner wants you to find and compare data for full-time employees in the sales department and full-time employees in the advertising department. Find the necessary employee data in the Excel spreadsheet titled Company Data. Download and open the spreadsheet, which lists data for all full-time employees. Employees 001 through 014 are all the employees in the sales department and employees 045 through 062 are all the employees in the advertising department. Find and compare the mean salaries and mean ages of the employees in the sales and advertising departments. Use a graphing calculator or the spreadsheet’s calculation features to complete your calculations. Explain to the owner how these values could be misleading. Find and compare the standard deviations of the salaries and ages of the employees in the sales and advertising departments. Tell how you would you explain the meaning of these values when you present them to the owner. Create side-by-side box-and-whisker plots for the salaries of the employees for both departments (using one number line). Create another pair of side-by-side box-and-whisker plots for the ages of the employees for both departments (using one number line). Tell how you would you interpret these box-and-whisker plots when you present them to the owner. Open your presentation and follow the directions to complete the Employee Salary and Age Comparison slide. Samples and Histograms The company owner wants to determine whether the cost of a certain computer training program is worthwhile. Employees often are not able to effectively judge their own computer skills, so the owner wants to test the employees. It would be too costly and time consuming to test all 177 employees; therefore, only a sample of the employees will be tested. You will simulate the results of the computer skills test and will display the employee’s test scores in a frequency table and histogram. The Company Data Excel file lists the employee numbers of all 177 employees in the company (Employee 001 through Employee 177). You must select a sample of 25 to 30 employees. Describe the type of sampling method that you will use and explain why you chose that method. Then use your method to select the group. List the employee numbers of the employees in your test group. You will now simulate testing the employees that you chose in Problem 1. Open the Company Data Excel sheet. Highlight columns C and E and select Format > Column > Unhide. Obtain the scores of each employee who took the test by selecting the corresponding cell in column D and removing the shading from that cell. List the scores as you obtain them. Possible scores range from 1 to 20. Create a frequency table of the scores. Use the scores to make a histogram. Explain how you would interpret the histogram to the owner. Follow the directions in the presentation to complete the Computer Skills Test Sample and Computer Skills Test Scores slides. Scatter Plots Now you will use technology to draw scatter plots and trend lines for employee data. Open the Company Data Excel file. Create a scatter plot for the data in columns B and C. Tell how you would describe to the owner the correlation between salary and age. Open a new spreadsheet, or insert a new worksheet in your Company Data File. List the salaries and computer scores of the employees who took the test in two columns in the spreadsheet. Select the data and create a scatter plot. Draw a trend line and display the equation of the trend line. Copy the scatter plot and trend line to the Salary and Computer Skills slide in your presentation. List the ages and computer scores of the employees who took the test in two columns in the spreadsheet. Select the data and create a scatter plot. Draw a trend line and display the equation of the trend line. Copy the scatter plot and trend line to the Age and Computer Skills slide in your presentation. Follow the directions in the presentation to complete these three slides: Salary and Age Salary and Computer Skills Age and Computer Skills Remember: You have 2 days to complete these slides. Make Data-Based Predictions It’s time to complete your final statistics task for the company owner. You will analyze bivariate data by interpreting the scatter plots and trend lines you have made. On the Make Data-Based Predictions slide, tell how you would describe to the owner the correlation between salaries and computer skills test scores. Give an example of using the trend line to make a prediction. On the Make Data-Based Predictions slide, tell how you would describe to the owner the correlation between age and computer skills test scores. Give an example of using the trend line to make a prediction. Submission Confirm that your presentation contains all of your work. A comparison of employees’ salaries and ages A histogram displaying employee scores on a computer skills test Scatter plots and trend lines representing salary, age, and computer skills test scores A data-based prediction for the company owner Submit your presentation to your teacher. © 2016 K12 Inc. All rights reserved. Page 3 of 3Copying or distributing without K12’s written consent is prohibited.

As a student, I know you sometimes get frustrated working on school projects or even struggle to complete assignments on time. You need online writing help to rid you off such troubles. And since we understand your needs, we provide you with reliable and professional academic writers to complete your projects on time and at an affordable price.


Order a Similar Paper Order a Different Paper

Looking for this or a Similar Assignment? Order a Paper Now