Excel CI & Hypothesis Testing

I have an Excel workbook containing survey responses on iPhone satisfaction broken down by several demographic segments. I need the statistical work polished and presented clearly so that I can make decisions with confidence.

Here is what I still need done:
• Draw a clean random sample (or several) from the full file so we can illustrate the effect of n on accuracy.
• Build confidence intervals for both a proportion (satisfied vs. not) and for the mean satisfaction score. Please show results for multiple confidence levels (90 %, 95 %, 99 %) and explicitly state each margin of error.
• Run hypothesis tests on that same survey data—one for a single proportion and one for a single mean—showing every step. I want the p-value generated with the legacy =TDIST function rather than =T.DIST so students can see the difference in syntax.
• Compare the confidence-interval conclusions with the formal test conclusions and note whether they agree.
• Include short, labelled “solution sets” that I can drop straight into a teaching deck: one set for the mean work and another for the proportion work.

Please keep everything inside one well-organised spreadsheet: raw data tab, working tabs with visible formulas, and a summary tab that highlights the final answers. Use Excel 365 functions only (TINV for critical t, etc.) and insert a concise comment wherever you use 1 – CL so the logic is crystal-clear. A brief write-up (one page max) describing your approach and key findings will round things out nicely.