2024_IE_Sample_size_calculator.xlsx
XLSX spreadsheet 46 KB Posted
- Attached to
- RFQ - Civil Engineering Services: Sinkhole Mit. , Stormwater, & Underground Utility Infra. & Road Wrk
- Solicitation number
- Not on record
- Issued by
- Shasta County, California
About this file
This is an Excel-based sample size calculator spreadsheet designed for Independent Evaluators working with Electrical Corporations to determine appropriate sampling sizes for initiatives. The calculator incorporates pre-set parameters including a 90% sample proportion, 5% margin of error for focus initiatives, 10% margin of error for non-focus initiatives, and a confidence level of 1.96. The tool sets minimum and maximum thresholds, with a minimum sample size of 15 and a maximum of 80 samples for field verification.
The calculator requires users to input specific initiative details including the initiative name/ID, population size, initiative priority (Focus or Non-Focus), and verification type (Field or Desk). The file contains fixed inputs in rows 12-17 that can only be modified by Energy Safety. The spreadsheet is designed to handle multiple initiatives simultaneously, allowing users to list multiple projects and calculate their respective sample sizes based on the established parameters.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Bid_Packet.pdf | ||
| 2023Mar6Form74R3_(7).pdf | ||
| std1000.pdf | ||
| RFQ_5PA4K00178.01_-_Redding_Training_Center_-_Fire_Props_2.pdf | ||
| Bidder_Instructions.pdf | ||
| gspd05-106.pdf | ||
| STD_204.pdf | ||
| Darfur_Certification_CAL_FIRE-720_.pdf | ||
| 2024_IE_RFQ_Attachments_B_to_E.xlsx | XLSX spreadsheet | |
| 2024_IE_RFQ.pdf | ||
| 2024_IE_RFQ_Q_A_Summary.pdf | ||
| 2024_IE_Reporting_Template.xlsx | XLSX spreadsheet | |
| 2024_IE_RFQ_Attachment_A.docx | DOCX document | |
| 2024_IE_ARC_Outline.pdf | ||
| 2024-12_Meeting_Notice_Independent_Evaluator_RFQ.pdf |
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 .