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]

Beceriler: Data Analysis, Veri Girişi, Excel

Daha fazlasını gör: 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

İşveren Hakkında:
( 1 değerlendirme ) London, Portugal

Proje NO: #19808077



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 Daha Fazla

%selectedBids___i_period_sub_7% gün içinde 100%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(13 Değerlendirme)

Bu iş için 9 freelancer ortalamada £145 teklif veriyor


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 gün içinde
(153 Değerlendirme)

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 Daha Fazla

£250 GBP in 5 gün içinde
(100 Değerlendirme)

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 gün içinde
(14 Değerlendirme)

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 Daha Fazla

£135 GBP in 7 gün içinde
(11 Değerlendirme)

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 Daha Fazla

£30 GBP in 5 gün içinde
(3 Değerlendirme)

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

£150 GBP in 3 gün içinde
(0 Değerlendirme)
£150 GBP in 4 gün içinde
(0 Değerlendirme)

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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% GBP
(0 Değerlendirme)