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

Evner: Data Analysis, Dataindførsel, Excel

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

Projekt ID: #19808077

## Tildelt til:

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 Flere

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

## 9 freelancere byder i gennemsnit £145 på dette job

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 dage
(153 bedømmelser)
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 Flere

£250 GBP in 5 dage
(100 bedømmelser)
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 dage
(14 bedømmelser)
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 Flere

£135 GBP in 7 dage
(11 bedømmelser)
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 Flere

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

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

£150 GBP in 3 dage
(0 bedømmelser)
0.0
£150 GBP in 4 dage
(0 bedømmelser)
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 Flere

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