i need a excel sheet made with the below data

group A is a single colum in excel

group B is a single colum in excel

use the below data

1v. Save your Excel file as "Needie. Ax/s" or "Needle B1 s. A (or whatever way to v. Exchangh the two data files in your colte datasets between the two groups so each group has both sets. se. You will need these to in Excel for each group data as you did for the last 1. Create a column for the mean (X4 and XB ) of each dats sequation on page 2). "Average" function under "Formulas" - "More Functions" eft and use Exoels. 2. Create a column for the variance (s2A and s2e) for each - "Statisticar" Excel's "VARA" function under "Statisticar to for each data set and use sample. 3. Create a column for the varia (refer to the t statistic equariance divided by the sample size of each data set. 4. Calculate the t-statistic usiong on page 2). 5. Compare the t-statistic using the equation on page 2 . degrees of freedlom ( v=n the tabulated t-value (see table below) based on the because you are (v=n1 or closest df) and a p=0.05 for a two-lailed thest is statistically less determining if the means are statistically different not if one Statistical analyses can be performed using software like Excel or statistical packages like SPSS, SAS, and R. Excel is limited in the types of statistical analyses it offers, but it is one of the most commonly used applications for data management, analysis like the t test. Pair up with another group to share date, and designate yourselves as either Group A or Group B. Then enter the other group's data in the same spreadsheet that you entered the pine needle length data for the last exercise. Follow these instructions: i. Make two columns in the Excel spreadsheet. Label the left column by typing "Group" in the first row. Label the right column as "Length (units)" in the same manner. ii. Type in your group's name (A or B ) in 80 rows of the left column. iii. In the right column, enter or copy the needle length data of the other group. one data point per row. iv. Save your Excel file as "Needle_A.x|s" or "Needle_B.x|s" (or whatever way to distinguish the two data files in your collaborating groups). v. Exchange the datasets between the two groups so each group has both sets