COMPARISON BETWEEN t-TEST AND F-TEST WITH EQUAL AND UNEQUAL VARIANCES USING EXCEL

COMPARISON BETWEEN t-TEST AND F-TEST WITH EQUAL AND UNEQUAL VARIANCES USING EXCEL

Registration ID: IJNRD_225438

Published ID: IJNRD2407330

DOI: Click Here to Get

Dr.Ch.Prasuna

Ms-Excel, data analysis pack, t-test

The user of excel for performing t-test faces two sample t-test with two options viz.,Two sample with equal variances and Two sample with unequal variances. Non statistics user often selects one of the two methods without any basis. The correct method is to perform F-test for equality of variances before doing t-test. This project is aimed at stimulating a large number of t-tests under both methods and estimate the chance of committing an error. We are motivated to exploit Random Generation tools in Excel. 1. To stress the importance of homogeneity of variances in conducting t-test. 2. To assess the behaviour of the two-tailed t-value for independent samples with and without assuming equal variances 3. To simulate two independent normal populations and examine the behaviour of t-statistic by taking resampling.

Published Paper   E-Certificate

"COMPARISON BETWEEN t-TEST AND F-TEST WITH EQUAL AND UNEQUAL VARIANCES USING EXCEL", IJNRD - INTERNATIONAL JOURNAL OF NOVEL RESEARCH AND DEVELOPMENT (www.IJNRD.org), ISSN:2456-4184, Vol.9, Issue 7, page no.d478-d484, July-2024, Available :https://ijnrd.org/papers/IJNRD2407330.pdf

Volume 9 Issue 7, July-2024

Pages : d478-d484

Paper Reg. ID: IJNRD_225438

Published Paper Id: IJNRD2407330

Downloads: 000121145

Research Area: Mathematics

Country: nellore, Andhra pradesh, India

Published Paper PDF: https://ijnrd.org/papers/IJNRD2407330.pdf

Published Paper URL: https://ijnrd.org/viewpaperforall?paper=IJNRD2407330

Journal Name: INTERNATIONAL JOURNAL OF NOVEL RESEARCH AND DEVELOPMENT(IJNRD)

ISSN: 2456-4184 | IMPACT FACTOR: 8.76 Calculated By Google Scholar | ESTD YEAR: 2016

An International Scholarly Open Access Journal, Peer-Reviewed, Refereed Journal Impact Factor 8.76 Calculate by Google Scholar and Semantic Scholar | AI-Powered Research Tool, Multidisciplinary, Monthly, Multilanguage Journal Indexing in All Major Database & Metadata, Citation Generator

Publisher: IJNRD (IJ Publication) Janvi Wave

This work is licensed under a Creative Commons Attribution 4.0 International License and The Open Definition

Call For Paper - Volume 10 | Issue 8 | August 2025

IJNRD is Scholarly open access journals, Peer-reviewed, and Refereed Journals, High Impact factor 8.76 (Calculate by google scholar and Semantic Scholar | AI-Powered Research Tool), Multidisciplinary, Monthly, Indexing in all major database & Metadata, Citation Generator, Digital Object Identifier(DOI) with Open-Access Publications.

INTERNATIONAL JOURNAL OF NOVEL RESEARCH AND DEVELOPMENT (IJNRD) aims to explore advances in research pertaining to applied, theoretical and experimental Technological studies. The goal is to promote scientific information interchange between researchers, developers, engineers, students, and practitioners working in and around the world. IJNRD will provide an opportunity for practitioners and educators of engineering field to exchange research evidence, models of best practice and innovative ideas.

Indexing In Google Scholar, SSRN, ResearcherID-Publons, Semantic Scholar | AI-Powered Research Tool, Microsoft Academic, Academia.edu, arXiv.org, Research Gate, CiteSeerX, ResearcherID Thomson Reuters, Mendeley : reference manager, DocStoc, ISSUU, Scribd, and many more

How to submit the paper?

Important Dates for Current issue

Paper Submission Open For: August 2025

Current Issue: Volume 10 | Issue 8

Last Date for Paper Submission: Till 31-Aug-2025

Notification of Review Result: Within 1-2 Days after Submitting paper.

Publication of Paper: Within 01-02 Days after Submititng documents.

Frequency: Monthly (12 issue Annually).

Journal Type: International Peer-reviewed, Refereed, and Open Access Journal.

Subject Category: Research Area