Question: Step-by-step instructions Download data: The data source is in 0-README (CDC PLACES (County-level) XLSX for the latest year available). Set up Excel: Open the class

Step-by-step instructions Download data: The data source is in 0-README (CDC PLACES (County-level) XLSX for the latest year available). Set up Excel: Open the class template. Paste/import the XLSX into 1_RAW (no edits). Filter NC: In 2_CLEAN, keep data for State = NC only. Keep columns: StateAbbr, LocationName, Measure, Data_Value (age-adjusted prevalence). Pivot to wide: Insert a PivotTable to reshape so each row is a county and the five chosen Indicators are columns of values (use the Average of Data_Value). Copy values back to 2_CLEAN. Add ENC flag: In 2_CLEAN, create Is_ENC so all ENC counties show "ENC", others "Non-ENC." (See template notes; use XLOOKUP/VLOOKUP or MATCH.) Compute stats (3_ANALYSIS): For each indicator and group (All, ENC, Non-ENC), compute: N, Mean, Median, Mode, Min, Max, Range, Variance, Standard Deviation. Charts (4_VISUALS): One Histogram per indicator (all NC counties). One Box-and-Whisker per indicator (ENC vs Non-ENC). Label axes, add clear titles, and a source footnote. Interpretation (3-5 bullets per indicator): Compare mean vs median (skewness), comment on spread/outliers, and state one policy-relevant takeaway about ENC vs Non-ENC. Complete the Canvas Quiz: Enter your computed numbers (rounded to 1 decimal) and answer the short conceptual questions. Submit: Upload the Excel workbook to

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!