# Primary excel course work

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]

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]​

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]

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

[20 marks]

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

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

Proje NO: #19808077

## Seçilen:

bluesea1990

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)
4.0

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

fatimatuzzohura

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)
6.4
choprac

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)
5.6
vandana1986

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)
4.4

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)
3.3

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)
2.3
Harsh049

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)
0.0
£150 GBP in 4 gün içinde
(0 Değerlendirme)
0.0
mohamedaithmida

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)
0.0