2024_IE_Sample_size_calculator.xlsx
XLSX spreadsheet 46 KB Posted
- Attached to
- Job Order Contract Phase 39-41 (JOC)
- Solicitation number
- 0000033725
- Issued by
- Shasta County, California
About this file
This is an Excel-based sample size calculator tool provided for Independent Evaluators working with Electrical Corporations, with oversight from Energy Safety. The calculator determines required sample sizes for various initiatives based on pre-set statistical parameters including a 1.96 confidence level, 90% sample proportion, and margins of error of 5% for focus initiatives and 10% for non-focus initiatives. The tool implements sampling guidance specified in an associated Statement of Work (SOW) and includes minimum threshold requirements of 15 samples and maximum field verification samples of 80.
The calculator requires users to input initiative names/IDs, population sizes, initiative priorities (Focus or Non-Focus), and verification types (Field or Desk). The tool's core statistical inputs (rows 12-17) are controlled exclusively by Energy Safety and cannot be modified by users. The calculator is designed to handle multiple initiatives simultaneously through dropdown selections and data entry in designated columns for initiative details.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Bid_Packet.pdf | ||
| RFQ_5PA4K00178.01_-_Redding_Training_Center_-_Fire_Props_2.pdf | ||
| STD_204.pdf | ||
| std1000.pdf | ||
| 2023Mar6Form74R3_(7).pdf | ||
| Darfur_Certification_CAL_FIRE-720_.pdf | ||
| gspd05-106.pdf | ||
| Bidder_Instructions.pdf | ||
| 2024_IE_ARC_Outline.pdf | ||
| 2024_IE_Reporting_Template.xlsx | XLSX spreadsheet | |
| 2024_IE_RFQ.pdf | ||
| 2024_IE_RFQ_Attachment_A.docx | DOCX document | |
| 2024_IE_RFQ_Q_A_Summary.pdf | ||
| 2024-12_Meeting_Notice_Independent_Evaluator_RFQ.pdf | ||
| 2024_IE_RFQ_Attachments_B_to_E.xlsx | XLSX spreadsheet |
Show all 15
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Sample Size Calculator
Sampling Size Calculator
Independent Evaluator:
Electrical Corporation:
| Inputs | ||||||
| Confidence level | 1.96 | Input | ||||
| Sample proportion | 90% | Output | ||||
| MOE - Focus | 5% | |||||
| MOE - Non-focus | 10% | Initiative | Population | Priority | Type of verification | Sample Size |
| Min threhold | 15 | 0 | ||||
| Max samples for field verification | 80 | 0 | ||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 | ||||||
| 0 |
Context This Excel file calculates the sample size needed for an initiative, incorporating all guidance stated in the SOW.
How to Use This Excel Follow these instructions to determine the required sample size for an initiative:
1. Enter Initiative Name: Input the name or ID of the initiative in column H.
2. Enter Population Size: Input the population of the initiative in column I. This must be a numeric value.
3. Select Initiative Priority: Choose the priority of the initiative (FOCUS or NON-FOCUS) from the dropdown menu in column J.
4. Select Verification Type: Choose the type of verification (FIELD or DESK) from the dropdown menu in column K.
5. Handling Multiple Initiatives: If you need to calculate sample sizes for more initiatives, list them in columns H (name or ID) and I (Population number). Then, drag down the dropdown selections in columns J, K, and L for each initiative. Ensure that the priority and verification type are selected for each initiative to obtain accurate sample sizes.
Please note that the inputs in rows 12 through 17 are fixed. Only Energy Safety can change these inputs.
image1.jpeg
File details come from the government source that posted it. Updated .