Need help with excel (Instructions are given) also please share the…

Question Need help with excel (Instructions are given) also please share the… Need help with excel (Instructions are given) also please share the links!!1. Two-Sample t-TestImage transcription textA B C D E F G H 1 Daily Sales of Store1 ($) Daily Sales of Store 2 ($) O 68494697 Please provide your … Show more… Show moreInstruction: Image transcription textTwo-Sample t-Test using the Data Analysis Toolpakin Excel This document includes instructions toconduct a two-sample t-test based on … Show more… Show moreImage transcription textData Analysis Analysis Tools Histogram Moving AverageRandom Number Generation Rank and PercentileRegression Sampling 4. Input: specify the r… Show more… Show moreImage transcription textt-Test: Two-Sample Assuming Unequal Variances ? X Input OKVariable 1 Range: $A$1:$A$60 T Cancel Variable 2 Range:$B$1:$8$50 Hypothesized Mean Difference: 0 H… Show more… Show moreImage transcription textt-Test: Two-Sample Assuming Unequal Variances ? X Input OKVariable 1 Range: $A$1:$A$60 T Cancel Variable 2 Range:$B$1:$8$50 Hypothesized Mean Difference: 0 H… Show more… Show moreImage transcription textReviewing the Report and Interpreting Results Here is the resultwe had for this particular test (I had to change the column widtha little to fit the text in the report). t-Test: Two-Sam… Show more… Show moreImage transcription textFor this particular test, if our alternativehypothesis is one-sided, we will look atthe one-tail part of the re… Show more… Show more2. One-way ANOVAImage transcription textA B C D E F G Weekly Sales of Store 1($) Weekly Sales of Store 2 ($) WeeklySales of Store 3 ($) $14,9… Show more… Show moreImage transcription textOne-Way ANOVA using the Data Analysis Toolpak inExcel This document includes instructions toconduct a one-way ANOVA test and revi… Show more… Show moreImage transcription textData Analysis Analysis Tools ‘I ..-;.-‘|-:: ‘3 i an: If F._- :to |’ . actorIth Replication Anova: Two-Factor Without ReplicationCorrelation Covariance Descriptive Statistics Ex… Show more… Show moreImage transcription textAnova: Single Factor ? X Input OK Input Range: $A$1:$C$51 +Grouped By: Columns Cancel O Rows Help Labels in first rowAlpha: 0.05 Output options Output Range: + O N… Show more… Show moreImage transcription textAnova: Single Factor ? X Input OK Input Range: $A$1:$C$51+ Cancel Grouped By: Columns O Rows Help Labels in firstrow Alpha: 0.05 Output options O Output Rang… Show more… Show moreImage transcription textswitched in this table compared to thetable we had in lecture. You canconfirm all the relationship… Show more… Show more  Math Statistics and Probability COMMERCE 1DA3 Share QuestionEmailCopy link Comments (0)