5-5 Analytical Report Excel File (2) Search Sneet Home Insert Draw Page Layout Formulas Data Review...

Transcribed Image Text:

5-5 Analytical Report Excel File (2) Search Sneet Home Insert Draw Page Layout Formulas Data Review View StatPlus Data Mining + Share Queries & Connections Clear Group + Az Flash-fill Data Validation + Properties Reapply Ungrfup Analysis Tools Data Analysis Get Data (Power Query) N6 Refresh All Stocks Currencies Geography NA Sort Filter Edit Links Advanced Text to Columns Remove Duplicates Consolidate What-if Analysis Subtotal Solver fx A B C D E F G H Sales Team Advertising I K I M N Data Analysis P Q R S T U Website 1 Company Year Size Spend Traffic Revenue 2 Company A 2020 4 50,000 200,000 100,000 3 Company A 2021 5 60,000 220,000 110,000 4 Company A 2022 3 45,000 180,000 95,000 Analysis Tools Random Number Generation OK Cancel 5 Company B 2020 6 70,000 240,000 120,000 Rank and Percentile 6 Company B 2021 4 55,000 210,000 105,000 7 Company B 2022 5 65,000 230,000 115,000 8 Company C 2020 3 40,000 170,000 90,000 9 Company C 2021 6 75,000 250,000 125,000 10 Company C 2022 4 50,000 200,000 100,000 11 Regression Sampling t-Test: Paired Two Sample for Means t-Test Two-Sample Assuming Equal Variances K 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 Ready Results Sheet2 Sheet8 clear data colleration revenue chart T-test -RE-AD Sheet9 main dataset Accessibility: Investigate + Error loading add-ins B + 100% Sales Team Advertising Website Company Year Size Spend Traffic Revenue Company A 2020 4 50,000 200,000 100,000 Company A 2021 5 60,000 220,000 110,000 Company A 2022 3 45,000 180,000 95,000 Company B 2020 6 70,000 240,000 120,000 Company B 2021 4 55,000 210,000 105,000 Company B 2022 5 65,000 230,000 115,000 Company C 2020 3 40,000 170,000 90,000 Company C 2021 6 75,000 250,000 125,000 Company C 2022 4 50,000 200,000 100,000 5-5 Analytical Report Excel File (2) Search Sneet Home Insert Draw Page Layout Formulas Data Review View StatPlus Data Mining + Share Queries & Connections Clear Group + Az Flash-fill Data Validation + Properties Reapply Ungrfup Analysis Tools Data Analysis Get Data (Power Query) N6 Refresh All Stocks Currencies Geography NA Sort Filter Edit Links Advanced Text to Columns Remove Duplicates Consolidate What-if Analysis Subtotal Solver fx A B C D E F G H Sales Team Advertising I K I M N Data Analysis P Q R S T U Website 1 Company Year Size Spend Traffic Revenue 2 Company A 2020 4 50,000 200,000 100,000 3 Company A 2021 5 60,000 220,000 110,000 4 Company A 2022 3 45,000 180,000 95,000 Analysis Tools Random Number Generation OK Cancel 5 Company B 2020 6 70,000 240,000 120,000 Rank and Percentile 6 Company B 2021 4 55,000 210,000 105,000 7 Company B 2022 5 65,000 230,000 115,000 8 Company C 2020 3 40,000 170,000 90,000 9 Company C 2021 6 75,000 250,000 125,000 10 Company C 2022 4 50,000 200,000 100,000 11 Regression Sampling t-Test: Paired Two Sample for Means t-Test Two-Sample Assuming Equal Variances K 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 Ready Results Sheet2 Sheet8 clear data colleration revenue chart T-test -RE-AD Sheet9 main dataset Accessibility: Investigate + Error loading add-ins B + 100% Sales Team Advertising Website Company Year Size Spend Traffic Revenue Company A 2020 4 50,000 200,000 100,000 Company A 2021 5 60,000 220,000 110,000 Company A 2022 3 45,000 180,000 95,000 Company B 2020 6 70,000 240,000 120,000 Company B 2021 4 55,000 210,000 105,000 Company B 2022 5 65,000 230,000 115,000 Company C 2020 3 40,000 170,000 90,000 Company C 2021 6 75,000 250,000 125,000 Company C 2022 4 50,000 200,000 100,000