Excel Assigment 3 steps missing only

User Generated

Nmmv

Business Finance

Description

Hi I have excel assignment, and I want to complete 3 more steps on the assignment using functions, I already done  most of this.

if you are good in this please let me know.. see the attached file below.

KSA_EBTM337_Sp11_Assignment_V4.docx 

I need this within 4 hours maximum.

Thanks,,,

Unformatted Attachment Preview

West Textile---Personnel Name Bill Jones Bob Marshall Don Smith Fred Johnson Jack Parsons Jim Evans Linda Flores Lisa Fuller Marsha Grayson Rick Fisher Shelly Hanson Phone Floor Office Dept. Years Exp. 5116 4 3 MKT 5859 3 14 MKT 5871 2 21 ADM 5886 4 17 ADM 5860 2 12 MKT 5876 2 11 ADM 5853 4 16 R&D 5860 3 14 R&D 5872 3 16 R&D 5324 2 18 MKT 5551 2 13 R&D Name Salary >=$40,000 9 9 2 4 8 5 4 5 8 10 5 Regression Name Bill Jones Jack Parsons Marsha Grayson Rick Fisher Salary 45,000.00 40,000.00 42,000.00 42,000.00 1953.333333 Salary 45,000.00 29,000.00 25,000.00 33,000.00 40,000.00 32,000.00 31,000.00 28,000.00 42,000.00 42,000.00 30,000.00 Analysis Major Skill Using MS-Excel to assist in decision-making Specific 1. Creating an Excel file from a formatted text file Skills 2. Using Excel's Data filtering capabilities for extracting relevant data 3. Using Excel's Graphing capabilities to create informative charts 4. Using Excel's mathematical capabilities (specifically logical functions and array functions) 5. Apply regression techniques to data 1. Download the file skills2.txt to your PC from your Assignment/Assignment2 folder on Blackboard. 2. Import this file into Microsoft Excel. Use the appropriate columns to convert this tab-delimited formatted text file into a Microsoft Excel file. 3. Change the format of the title "West Textile - Personnel" to the format (Red, Arial 14 Font in merged cells) to resemble the form of Figure 1 below. 4. Use the Data - Filter - Advanced Filter menu commands to extract all people whose salaries are equal or above $40,000. The data range, criteria range and output range are visible in the spreadsheet. 5. Perform a regression of salary against number of years of experience. Use the Linest function so create regression coefficients. Use the regression coefficients as shown and enter formulas to calculate the predicted salary in column H. (Hint: For help with Linest function refer to this youtube video, http://www.youtube.com/watch?v=WAXv9y1wIL4 or you can, of course, Google ‘linest function’). 6. Create a chart which graphs the actual salary and predicted salary against the number of years of experience. The X-Y graph that you will create is shown below in Figure 2. Please format the data series appropriately, change the fonts and colors as required. 7. Provide a last column titled Status (Column I) after the predicted Salary column. In this column you will enter an IF function which evaluates to "Manager" if the person is on Floor 4, or evaluates to "Executive" otherwise. 8. Create borders of appropriate thickness for the entire spreadsheet as shown in Figure 1 below. 9. Save the file using your first initial and last name. For example, John Doe would save the file as jdoe.xlw or jdoe.xls or jdoe.xlsx 10. Follow your instructor’s instructions on how to submit your assignment. 11. The printed form of your spreadsheet should appear exactly as follows (except replace ‘John Doe’ with your name): Figure 1. Output Sample 12. Your graph should appear exactly as follows (except replace ‘John Doe’ with your name): Figure 2. Graph of Salaries versus Number of Years of Experiences
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

This question has not been answered.

Create a free account to get help with this and any other question!

Similar Content

Related Tags