2024_IE_Sample_size_calculator.xlsx
XLSX spreadsheet 46 KB Posted
- Solicitation number
- 0000033649
- Issued by
- Sacramento County, San Diego City, California
About this file
This is a sample size calculator Excel spreadsheet template used by Independent Evaluators working with Electrical Corporations. The calculator is designed to determine appropriate sample sizes for initiatives based on specified confidence levels (1.96), sample proportions (90%), and margins of error (5% for focus initiatives and 10% for non-focus initiatives). The tool includes minimum thresholds of 15 samples and maximum field verification samples of 80, indicating these are the operational bounds for any sampling activity.
The calculator requires users to input initiative names, population sizes, initiative priorities (Focus or Non-Focus), and verification types (Field or Desk). The template is structured to handle multiple initiatives simultaneously, with fixed input parameters in rows 12-17 that can only be modified by Energy Safety. The tool appears to be part of a larger scope of work (SOW) and is designed to ensure consistent sampling methodology across evaluation activities.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 24-270_Q_and_A.pdf | ||
| 24-270_Addendum__1_Letter.pdf | ||
| 24-270_SB_Solicitation.pdf | ||
| 2024_IE_RFQ_Attachments_B_to_E.xlsx | XLSX spreadsheet | |
| 2024_IE_RFQ_Attachment_A.docx | DOCX document | |
| 2024_IE_RFQ.pdf | ||
| 2024_IE_ARC_Outline.pdf | ||
| 2024_IE_Reporting_Template.xlsx | XLSX spreadsheet | |
| 2024-12_Meeting_Notice_Independent_Evaluator_RFQ.pdf | ||
| 2024_IE_RFQ_Q_A_Summary.pdf | ||
| RFP_P_DRR24051_Solicitation_Link.docx | DOCX document | |
| 24-272_Addendum__1_Letter.pdf | ||
| 24-272_IFB_W_Adden__2.pdf | ||
| 24-272_Addendum__2_Letter.pdf | ||
| 24-272_IFB.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 .