Use Markdown to Type By: Your First and Last Name. Use comments to describe what each line is doing in your Jupyter file. All code written in code cells must display output. If you create a list, print the list upon creation.

Understanding Data Structures

Use a Markdown cell to explain the difference between mutable and immutable objects. Discuss why certain data structures $($lists or tuples$)$ might be preferred in different situations.

Working with Data Structures

Create a list named yourlastname$\_$sales$\_$q$1$ with the following values: $[1200,850,900,1150,950].$ Calculate and print the mean and median of these sales figures.

After reviewing the data, your manager suggests including a promotional boost for one product. Copy yourlastname$\_$sales$\_$q$1$ into a new list called adjusted$\_$sales$\_$q$1$ and append the value $1300$ to adjusted$\_$sales$\_$q$1.$ Recalculate and print the new mean and median.

Conditional Logic

Scenario: You are asked to review employee performance based on their contribution to recent projects.

Task: You have a list of scores $[78,85,62,90,88]$ representing the performance of five employees. Write a Python function that takes a list of scores and returns the distribution of performance ratings:

Excellent: $90$ and above

Good: $80-89$

Satisfactory: $70-79$

Needs Improvement: $60-69$

Unsatisfactory: Below $60$

Data Cleaning

Scenario: The DataPioneers recently collected customer feedback and your task is to clean and prepare this data for sentiment analysis.

Task: Store the following raw customer feedback text:

'Excellent! service; but the product is too expensive. Great, customer care.$\text{'}$

Task: Write a Python function to clean this text by:

Removing punctuation.

Converting all text to lowercase.

Splitting the cleaned text into individual words.

Task: Identify and print the unique words in the cleaned data.

Above and Beyond for Extra Credit!

Scenario: DataPioneers needs to optimize its budget across different departments. Your task is to analyze the expenses and suggest areas for potential savings.

Task: Create a dictionary where the keys represent different departments $($e$.$g$.,$ "Marketing," "Development," "Operations"$)$ and the values are lists of monthly expenses for the first quarter.

Task: Write a Python function to calculate and print the total and average expenses for each department.

Task: After reviewing the budget, the company decides to increase marketing efforts in the second month. Simulate a $15\%$ increase in marketing expenses for the second month, update the dictionary, and recalculate the total and average expenses for that department.