Data Cleanup and Visualization in Excel

We have a workbook with two sheets. The data is scraped from the blogs of 385 websites and contain key metrics around total word count by URL.

1. I'm stuck with a VLOOKUP that isn't working the way it's expected. So the first task is to combine the data from both sheets in the workbook

2. Then, we'll tag in your help for analysis. Here are the primary calculations we'll want to make from the data present

Calculate and log the following for each website
  Average total pages in blog section
  Average word count
Calculate and log the following for each category
  Average total pages in blog section
  Average word count
Caculate and log the following
  Correlation between revenue and average page count
  Correlation between revenue and average word count
  Correlation between funding amount and average page count
  Correlation between funding amount and average word count
Calculate and log the following
  Average revenue among sample
  Median revenue among sample
  Average employee count
  Median employee count

3. Last step is to create basic visualizations (charts) for the key calculations. We'll pass this off to our designer, so it doesn't need to be aesthetically pleasing.

Preference given to anyone who can complete this in 24 hours.


Site: Upwork.com | Data Science & Analytics

Published by:

Project page in Upwork.com

Budget: by agreement

New projects

A complete list of projects is available on the projects page

Загрузка проектов

Similar projects

300 image to PDF file(data extraction)simple images typing

Kindly message me via Telegram for more details about the job. [email protected]

PDF to Word copy typing (Data extraction project)

We are looking for a freelancer who can handle this job, no experience needed. If you are intrest...

See message thread from previous contract

see message thread from the previous contract. Can you continue this work?

PDF to Word copy typing (Data extraction project)

We are in search of some freelancers who are able to convert PDF files into MS Word by extracting...

Scrape data from website into excel

Hi there. i need you to scrape all of the data in the listings in this map: https://wavepoolmag.c...

300 image to PDF file(data extraction)simple images typing

Kindly message me via Telegram for more details about the job. [email protected]

Simple data collection from images to PDF format ( easy typing job)

Our company needs freelancers who can handle this project task thank you.

Covert images to PDF file (data extraction) spd typing

Kindly message me via Telegram for more details about the job. [email protected]