Primary excel course work

Task 1

Select 30 companies from the excel file called Assessment Data –BloombergFTSE100 and create a data file and make sure you select at least one company from each sector. The spreadsheet contains 22 sectors which are – Household & Personal Products; Materials; Banks; Food, Beverage & Tobacco; Telecommunication Services; Pharmaceuticals, Biotechnology & Life Sciences; Utilities; Insurance; Transportation; Commercial & Professional Services; Consumer Services; Food & Staples Retailing; Capital Goods; Diversified Financials; Health Care Equipment & Services; Consumer Durables & Apparel; Energy; Retailing; Media & Entertainment; Real Estate; Software & Services ; Technology Hardware & Equipment.

Make sure for each company you have the data on the 6 variables namely Sector, Price, Operating Expense, Number of Employees, Revenue and Net Profit. ​ [10 marks]

Task 2

For each of the 5 quantitative variables construct a percentage frequency distribution table and present the data using appropriate charts. Comment on your findings.​

[20 marks]​

Task 3

Prepare a cross tabulation using sectors (rows) and revenue (columns). Compute row percentages for the cross tabulation and construct a stacked bar chart showing the percentage distribution of revenue within each sector type. Comment on the relationship between variables. [10 marks]

Task 4

Compute the mean, median, standard deviation, IQR (Interquartile Range) for the number of operating expenses and comment on your results.

[20 marks]

Task 5

Develop a scatter diagram to analyse the relationship between operating expenses and revenue, where operating expenses is the independent variable and revenue the dependent variable. Comment on the relationship.

[5 marks]

imate the regression equation using the above variables and comment on the slope variable.

Find the coefficient of determination (R-squared) and comment on its value.

[15 marks]

Evner: Data Analysis, Dataindførsel, Excel

Se mere: excel training youtube, microsoft excel training courses, best online excel training, best excel training youtube, free online excel course with certificates, excel for beginners free, free online excel courses with certificate, best excel tutorial, excel calculate work hours days, excel contract work, vba excel spreadsheet work, excel offline work home, access excel freelance work, freelance access excel project work, excel freelancing work delhi india, excel spreadsheet work bank statement, hyperlinks excel longer work pdf, excel contract work vba canada, code excel compare work, project export excel weekly work

Om arbejdsgiveren:
( 1 bedømmelse ) London, Portugal

Projekt ID: #19808077

Tildelt til:


Hello. Welcome! I'm excited that you’re here! *****Excel VBA Expert****** 1. I am an expert in Excel(VBA), Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. 2. Have done many projects i Flere

£100 GBP in 7 dage
(13 bedømmelser)

9 freelancere byder i gennemsnit £145 på dette job


Hi, I am experienced on Microsoft Access , Excel and VBA, Powerpoint. I can start your job immediately also. Please contact me to discuss the project in details. Thanks

£188 GBP in 3 dage
(153 bedømmelser)

Hi There, I read your project details and it's my kind of work. I am Charu Chopra residing in USA. I have completed my MBA in Finance and IT. About my skills: Projects undertaken: • Completed 100 plus Excel based P Flere

£250 GBP in 5 dage
(100 bedømmelser)

Hi, I can do this job efficiently. I have more than 10 years of experience in this filed. I am flexible about working time and money. I believe work speaks better than words. Hope to have a positive response.

£150 GBP in 3 dage
(14 bedømmelser)

hi thanks for the opportunity, I have gone through your project description and found it compatible with my skills. I am fully aware with all kind of writing styles MLA, APA, Harvard etc. However, I want to mention her Flere

£135 GBP in 7 dage
(11 bedømmelser)

Hi I saw your project and want to help with it if you will accept my proposal. Of course I cannot convince you to but I can give you an assurance of a good job. i am very much happy to bid on your project, please ping Flere

£30 GBP in 5 dage
(3 bedømmelser)

I have a good command in ms excel and complete the work in given time period.

£150 GBP in 3 dage
(0 bedømmelser)
£150 GBP in 4 dage
(0 bedømmelser)

Hello sir ! We are a group of expert, each with a master's degree in economics and statistics , we have a good experience and brilliant skills in statistical analysis using Excel, we promise you for a quality work. at Flere

£150 GBP på 1 dag
(0 bedømmelser)