Excel PDF Data Analysis and solve problems

I’m tackling an assignment where the raw data lives inside several PDFs. I need that information transferred into Excel, organised, and analysed so I can resolve the specific questions provided in the homework.

Here’s what I expect:

• Import & clean the PDF tables in a well-structured workbook (one dataset per sheet, consistent headings).
• Apply the necessary Excel formulas—lookups, logical statements, basic stats—so each problem is solved directly in-sheet.
• Provide a short written summary that points to the cell ranges or sheets where each answer can be found.

Clarity and accuracy matter more than flashy visuals; charts are optional only if they help explain a result. Please document any assumptions or transformations so I can follow your logic.

If you’re confident working with PDF imports, data cleaning, and formula-driven problem solving, I’d love to hand this over to you right away.