Blog

Based on your results in Q4 and Q5, does the data support the perception that PharmaFly is frequently late with international shipments?

Case Study 3: Salary Equity at “TechGiant” Original Assignment: Week 3 (Real Estate Sampling & Confidence Intervals) New Scenario: “TechGiant” is a software firm located in the San Francisco Bay Area. You are an HR Analytics Consultant hired to audit the company’s compensation structure. Specifically, the company classifies employees as either “Engineering” (Software Devs, QA) or “Operations” (Sales, HR, Marketing). There is a concern that Operations employees are being underpaid relative to market rates compared to Engineers. You have obtained a random sample of recent hires: 40 Engineering employees and 35 Operations employees. You need to calculate the mean salaries and create confidence intervals to see if the ranges overlap significantly. See Spreadsheet: Midterm_TechGiant_Salary_Sample_75.csv Data Summary: ●    Engineering (n=40): Mean = $145,000, Std Dev = $15,000 ●    Operations (n=35): Mean = $95,000, Std Dev = $10,000

Case Study 2: CyberSafe Network Intrusion Analysis Original Assignment: Week 2 (Defects & Time Between Defects)New Scenario:You are the Lead Security Analyst for “CyberSafe,” a managed security service provider. Instead of manufacturing defects, you are monitoring Network Intrusions (hacking attempts) on a client’s firewall.You have a dataset covering the last 200 hours of operation. The data tracks:1.   Intrusions_Per_Hour: Modeled using the Poisson Distribution.2.   Hours_Between_Intrusions: Modeled using the Exponential Distribution.Your analysis shows that the average number of intrusions per hour (λ) is 3, and the mean time between intrusions (μ) is 0.33 hours (20 minutes). Management needs to know the probability of being overwhelmed by attacks in a single hour, and the probability of having a quiet period to perform maintenance.

Next, calculate the probability that a shipment is late given it was shipped by PharmaFly AND it is International.Enter your answer rounded to four decimal places.

Based on the descriptive statistics, what is the On-Time Percentage for PharmaFly? (Enter as a decimal, e.g., 0.85).

Calculate the Margin of Error for the 95% Confidence Interval for the Operations mean salary.

Using the Fine Art dataset, run a linear regression of Rating (Y) on Price (X).Enter the R-squared (R²) value rounded to three decimal places.

In the Linear Model, the Slope is 0.0001 and Intercept is 60. What is the predicted rating for a painting costing $5,000?

Using the University dataset, run a linear regression of Value Score (Y) on Student Satisfaction (X).Enter the slope coefficient for Satisfaction, rounded to four decimal places.

When you create a scatter plot of Price (X) vs Rating (Y) using the Fine Art dataset, what overall pattern do you see?