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.
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.
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.
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.
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
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
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.
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