Expert answer:Need business and finance help with an Excel Proje

Answer & Explanation:KSA_EBTM337_Sp11_Assignment_V4 (2).docx skills2.txt Look at the homework description at the first file and follow the steps. the second file below it is the Data tasks that you are going to use on Excel .Use Excel  to do the work.
ksa_ebtm337_sp11_assignment_v4__2_.docx

skills2.txt

Unformatted Attachment Preview

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
West Textile—Personnel
Name Phone Floor
Bill Jones 5116
Bob Marshall
Don Smith
5871
Fred Johnson
Jack Parsons
Jim Evans
5876
Linda Flores
Lisa Fuller 5860
Marsha Grayson
Rick Fisher 5324
Shelly Hanson
Office Dept.
4
3 MKT 9
5859 3
14
2
21 ADM
5886 4
17
5860 2
12
2
11 ADM
5853 4
16
3
14 R&D
5872 3
16
2
18 MKT
5551 2
13
Years Exp. Salary
45,000.00
MKT
9
29,000.00
2
25,000.00
ADM
4
33,000.00
MKT
8
40,000.00
5
32,000.00
R&D
4
31,000.00
5
28,000.00
R&D
8
42,000.00
10
42,000.00
R&D
5
30,000.00
…
Purchase answer to see full
attachment

How it works

1. Paste your instructions in the instructions box. You can also attach an instructions file
2. Select the writer category, deadline, education level and review the instructions 
3. Make a payment for the order to be assignment to a writer
4.  Download the paper after the writer uploads it 

Will the writer plagiarize my essay?

You will get a plagiarism-free paper and you can get an originality report upon request.

Is this service safe?

All the personal information is confidential and we have 100% safe payment methods. We also guarantee good grades